Results 1 to 9 of 9
Aug 29, 2012, 02:35 #1
[SQL Server 2005] Group by between interval dates
Hi all, I have one question for you.
In SQL Server it's possible GROUP BY between interval dates ?
I tried this, but I have error.
Thanks in advance for your help.
SELECT [DATE-E], [TYPE-V] FROM dbo_40 WHERE 1 = 1 AND [DATA-E] BETWEEN '2012-07-04' AND '2012-07-31' AND ([TYPE-V] = '5') GROUP BY [DATE-E] BETWEEN '2012-07-04' AND '2012-07-31, [TYPE-V];Thanks you very much for your help
I'm really happy for your quickly answer.