Union and If Exists - not working together - Please help
Posted
by needshelp
on Stack Overflow
See other posts from Stack Overflow
or by needshelp
Published on 2010-04-05T18:15:53Z
Indexed on
2010/04/05
18:23 UTC
Read the original article
Hit count: 360
I need to get dummy values if they do no rows returned from table. The If exists works by itself, but gives error with a Union. Can someone please guide me with a solution or a workaround?
create table test1 (col1 varchar(10))
create table test2 (col1 varchar(10))
create table test3 (col1 varchar(10))
insert test1 values ('test1-row1')
insert test1 values ('test1-row2')
insert test2 values ('test2-row1')
insert test2 values ('test2-row2')
select col1 from test1
union
select col1 from test2
union
if exists (select * from test3)
select col1 from test3
else
select 'dummy'
© Stack Overflow or respective owner