T-SQL QUESTION

[keithb]

What is the general form for a stored procedure that does two select
statements and returns a true indication if all of the records from one
select statement are included the records returned by the other select
statment?

Thanks,

Keith

 

[bruce barker \(sqlwork.com\)]

if you are using 2005, then

if exists(select * from table1
except
select * from table2)
return 0
if exists(select * from table2
except
select * from table1)
return 0

return 1


-- bruce (sqlwork.com)

 

[Jeff Dillon]

You should always be able to combine this type of logic in a single
statement

Jeff