为乐而来

摘要： DECLARE @date CHAR(10)SET @date = '2010-12-16'SET @date = convert(varchar(10),getdate(),120)SELECT SUN = MAX(CASE WHEN a.xq = 1 THEN CONVERT(CHAR(2),a.number) ELSE '' END), MON = MAX(CASE WHEN a.xq = 2 THEN CONVERT(CHAR(2),a.number) ELSE '' END), TUE = MAX(CASE WHEN a.xq = 3 阅读全文