高手支招,看看这个表怎么实现
表
RID StartDate EndDate Value1 Title Value2
SAL 2005-11-01 2005-11-04 100 ABF 20
TWIN 2005-11-01 2005-11-04 102 ABF 20
DBL 2005-11-01 2005-11-04 101 ABF 20
TRP 2005-11-01 2005-11-04 99 ABF 20
如何从上表得到如下表
Period SAL TWIN DBL TRP ABF
2005-11-01/2005-11-02 100 102 101 99 20
2005-11-02/2005-11-03 100 102 101 99 20
2005-11-03/2005-11-04 100 102 101 99 20