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

Filed under:
|
|
|

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

Related posts about sql-server

Related posts about union