Help with Cursors and inserting rows

[ehenry]

I have a table that contains trade deals, there are some trades known as Strips that come in as one deal, however they need to be displayed as if they were multiple deals. For example a Jul-10 - Aug-10 Strip would show up as one row in the table, I need to display this as two rows with the same information, but one for Jul-10 and one for Aug-10. I have a detailed spreadsheet with some sample data to show exactly what I am trying to achieve. So far I am pulling only the Strip Deals from the table and placing them in a Table Variable. I am assuming I would use a cursor to add rows to the Table Variable and then Select from that the Data I want to Display. I would like to know if there is some better way of doing this. Thank you.

 

[PWise]

Try this

Select StartDate,* 
from Treaddeals
Union
Select EndDate,* 
from Treaddeals

 

[ehenry]

That wont work, The Strips can be more than just 2 Months. You could have Mar-10 - Jun-10 with a startdate of 3/1/2010 and an enddate of 6/30/2010. That would leave out the months in between. I should have Explained that. Thanks though.

 

[bborissov]

Could you please post some example data and what you want as a result from it?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[PWise]

You would need a calander table and join on Calander date between StartDate And EndDate

Select * 
from Treaddeals
inner join calander 
on Calanderdate Between StartDate and EndDate