[SQL Server] Get data for the past one year (365 days) |
| Get data for the past one year (365 days) Posted: 23 Aug 2013 03:09 AM PDT I am trying to view data for past one year ...Don't know whats wrong with the following:select ProdMonth ,ProdYear from Productionwhere DATEADD(yyyy,-1,getdate())Kindly advise |
| Get data month to calander week Posted: 23 Aug 2013 07:08 AM PDT Hello all,I need two sample sqlserver queries 1. query get the data 1st date of the month to calendar week like week 1 , week 2 , week 3 etc.2. Second I need a query example the query runs always before Thursday get the previous sum of week data but end date always Thursday?Thanksfkh |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment