Dear sir,
I want to Weekly report of sales in month how i write sql Query
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Feb 20, 2013, 10:58 PM
hi,
your Requirement is not somuch clear, but you can use differnt date function like datepart, datename etc to achive your requirement.
please refer
http://sqlserverpedia.com/wiki/Built-in_Functions_-_Date_and_Time_Functions
http://www.w3schools.com/sql/sql_dates.asp
hope this will help you.