Home Forums SQL Server 2005 T-SQL (SS2K5) create date list RE: create date list

  • December 3, 2013 at 7:49 am

    #1670396

    spin (12/3/2013)

    Hi

    i have a table with accountid, stockid, startdate, enddate.

    i need to create a table which is a list of dates between the start/end dates.

    not sure where to begin??

    thanks.

    While I agree with Sean, you can almost certainly do whatever it is you want to do by joining to a calendar table. One of thousands of links here[/url].

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.