SQL Query for finding the data weekwise

#1 (**permalink**) 03-03-2008, 01:11 PM

Hi,

I just want to make a Report which show the Data as following fomat-

Code:

Week Of                                        Tickets
01/01/2007      01/07/2007                  5
01/08/2007      01/14/2007                  7
.............         ..............                   .

Its give the report like above on the basis of givin date parameter which user will choose like when User choose the Date From to 01/01/2007 to 03/03/2008 then it will show all the records Week wise like above example..
how can I featch this reports with what Query I need to run please help if any one have Idea..it will be very helpful for me.

Thanks,
MShastri

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

User Name		Remember Me?
Password