Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hisxlnc
Starting Member
1 Post |
 Posted - 2011-10-19 : 00:08:35
|
| My table PRODUCT has 3 columns: Product_ID INTRODUCED_DATE WITHDRAWAL_DATEI need to create a derived table PRODUCT_ALL_DATES from this table that list all the dates that a Product was active.The Date ranges are INTRODUCED_DATE (Start Date) and WITHDRAWAL_DATE(End Date)How can I achieve this in SQL Server?I have indicated the sample output in the attached image.http://imgur.com/vOBVaThanks!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
List all Dates between two Date columns of a table