How to Group Weekwise in SQLHi to all
i need to generate weekwise sales REPORT FOR THE particular month.
in this case user select the month name,item name only then i will generate the report in following format
for eg month name July , item Name XYZ
then i needs to generate report in the following format
Week Duration Qty Amount
1 01-Jun to 07-Jun 10 10.00
2 08-Jun to 14-Jun 15 15.00
3 15-Jun to 21-Jun 8 8.00
4 22-Jun to 28-Jun 4 4.00
5 29-Jun to 30-Jun 13 13.00
How can i write the Query in SQL.
if any one know the answer let me know..
Thanks & Regards