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)
"keithb" <kb******@dslextreme.com> wrote in message
news:u%****************@TK2MSFTNGP03.phx.gbl...

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

[Jeff Dillon]

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

Jeff
"keithb" <kb******@dslextreme.com> wrote in message
news:u%****************@TK2MSFTNGP03.phx.gbl...

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