Smash125 (12/16/2013)
How toExtract the data based on the present quarter and last quarter in SQL
Please let me know
Regards,
Praveen
SELECT TheData
FROM dbo.SomeTable
WHERE SomeDateColumn >= DATEADD(qq,DATEDIFF(qq,0,GETDATE())-1,0)
;
--Jeff Moden
Change is inevitable... Change for the better is not.