表示对数据库友好的时间表

Question

如何转换如下格式的花名册

Aug-03准备

一种方法使用union all:

select name, 'Aug-01' as date, [Aug-01] as position
from t
union all
select name, 'Aug-02' as date, [Aug-02] as position
from t
select name, 'Aug-03' as date, [Aug-03] as position
from t;