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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL-Select with multipile Output of Records

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-27 : 23:20:41
Adam writes "Dear Sirs,
i have a table like this.

Date1 Date2
Record1 12.02.2001 25.02.2001
Record2 24.02.2001 16.03.2001
Record3 24.03.2001 26.02.2001

I want to have a output like this.

Record1 12.02.2001
Record2 24.02.2001
Record1 25.02.2001
Record3 26.02.2001
Record2 16.03.2001
Record3 24.03.2001

Is it posible to make it with ONE Select statement ?

Best regards

Adam"
   

- Advertisement -