sqlСÎÊÌâ

SQL code:

DECLARE @SQL NVARCHAR(4000)
SET @SQL='SELECT ISNULL([iID],'''') [Àà±ð],'
SELECT @SQL=@SQL+' SUM(CASE WHEN [Date]='''+[Date]+''' THEN [st] ELSE 0 END) ['+[Date]+'],' from (SELECT DISTINCT [Date] from #T_Convert_Year)T_Date
SET @SQL=LEFT(@SQL,LEN(@SQL)-1)+' from #T_Convert_Year GROUP BY [iID] ORDER BY [iID]'

EXEC(@SQL)

[img=http://hiphotos.baidu.com/aaajedll/pic/item/e0ba31108aefa1f9c3fd7893.jpg][/img]

Àà±ðÆäʵÊÇÓÐ3¸ö-1£¬0£¬1£¬µ«ÊÇ-1µÄÊý¾ÝûÓУ¬ËùÒÔ¾ÍûÏÔʾ£¬Ôõô+Ò»¸ö-1½øÈ¥£¬ÓеÄʱºò0Êý¾ÝûÓÐÒ²ÊÇûµÄ
ÎÒÏëÒªµÄ¹¦ÄܾÍÊDz»¹ÜÊý¾ÝÓÐûÓУ¬Èç¹ûûÓУ¬¾ßÌåµÄÖµ¿ÉÒÔÓÃ0±íʾ£¬ÄÇÒ»ÐбØÐë´æÔÚ

---

---

´óÎÊÌ⣺ͼƬ¿´²»µ½

---

SQL code:
DECLARE @SQL NVARCHAR(4000)
SET @SQL='SELECT b.iID [Àà±ð],'
SELECT @SQL=@SQL+' SUM(CASE WHEN [Date]='''+[Date]+''' THEN [st] ELSE 0 END) ['+[Date]+'],' from (SELECT DISTINCT [Date] from #T_Convert_Year)T_Date
SET @SQL=LEFT(@SQL,LEN(@SQL)-1)+' from #T_Convert_Year a right join (select 1 as iID union select 0 union select -1) b on a.iID=b.iID GROUP BY b.[iID] ORDER BY b.[iID]'

EXEC(@SQL)

---

ÒýÓÃ

SQL code
DECLARE @SQL NVARCHAR(4000)
SET @SQL='SELECT b.iID [Àà±ð],'
SELECT @SQL=@SQL+' SUM(CASE WHEN [Date]='''+[Date]+''' THEN [st