T-SQL

Last Post 18 May 2006 06:00 PM by cmdr_jpskywalker. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
seema.nare
New Member
New Member

--
18 May 2006 02:18 AM
Hello,

I've date columns in the table with date_from and date_to. eg 15/06/06 and 17/06/06
And I want to write a query that will generate the rows eg as mentioned above., the query should give the o/p as different rows as shown below:
15/06/06
16/06/06
17/06/06
How should I write the query for the same? Please help.

Regards.
cmdr_jpskywalker
New Member
New Member

--
18 May 2006 06:00 PM
check this out:
http://sqlforums.windowsitpro.com/w...erthread=y

it uses number but can easily be a date. you can find the sequence date generator on the same forum.
You are not authorized to post a reply.

Acceptable Use Policy