I would highly recommend you NOT use a cursor for this. You should instead use a tally table. You can read about them, how to set it up and use by reading the article in my signature about splitting strings.
Using the same ddl as previously posted (much thanks for that). This type of thing is something you should post with future questions.
select *, dateadd(d, N, startdate)
from Place p
cross apply tally t
where N <= datediff(d, startDate, enddate) + 1
That is a lot simpler, faster and easier to maintain. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/