SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

General DB Chat If it is related to the database world, post your question or comment here.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > General DB Chat

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 03-03-2008, 01:11 PM
MShastri
 
Posts: n/a
Default SQL Query for finding the data weekwise

Hi,

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

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote
Reply

« lemme know | - »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Moderation Tools:



All times are GMT. The time now is 08:49 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2007 SQL Recipes

1 2 3 4 5 6 7