question about select - SQL Server Forums

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

Transact-SQL (2000)

question about select

Author

Topic

shannara
Starting Member

2 Posts

Posted - 2005-12-05 : 09:09:33

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-05 : 09:13:24

See if this helps you
http://www.sqlteam.com/item.asp?ItemID=2652

Madhivanan

Failing to plan is Planning to fail

shannara
Starting Member

2 Posts

Posted - 2005-12-05 : 09:22:55

no.
I just want to do what I stated above.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-05 : 09:31:55

like this ?

create table #name
(
	rec_id	int,
	Name1	varchar(10),
	Name2	varchar(10),
	Name3	varchar(10)
)
insert into #name (rec_id, Name1) select 1, 'one'
insert into #name (rec_id, Name1, Name2) select 2, 'two', 'two-Two'
insert into #name (rec_id, Name1, Name2, Name3) select 3, 'three', 'three-3', 'three-4'
insert into #name (rec_id, Name1, Name3) select 4, 'four', 'four-4'

select rec_id, Name1
from	#name
where	Name1 is not null
union all
select rec_id, Name2
from	#name
where	Name2 is not null
union all
select rec_id, Name3
from	#name
where	Name3 is not null
order by rec_id