如何造日期列
- SQL code
SELECT Uid, SUM(Money), [如何造] FROM USER GROUP BY Uid表中没有日期列，但是因为需要我想造个日期列，从2012-1-1开始到今天的日期,当然数量都是一样的，只要有日期列就OK
[解决办法]
- SQL code
SELECT CONVERT(VARCHAR(10),DATEADD(DAY,number,'2012-01-01'),23) AS DateFROM master..spt_valuesWHERE type = 'P' AND DATEADD(DAY,number,'2012-01-01') <= GETDATE()