Set NoCount On
Declare @A Table (i int)
Declare @B Table (j int)

Insert into @A Values (1)
Insert into @A Values (2)
Insert into @A Values (3)

Insert into @B Values (1)
Insert into @B Values (2)
Insert into @B Values (3)


select case when exists
(
select *
where 
	(select COUNT(*) from(
				Select * FROM @A
				INTERSECT
				Select * FROM @B )d )= (select COUNT(*) from @A) 
	
	and (select COUNT(*) from @A)=(select COUNT(*) from @B)
) then 1 else 0 end 

--case when (B-A)=Null And (A-B)=Null then 1 else 0

select case when not exists (select * from @A 
	                     except
	                     select * from @B) and 
	        not exists (select * from @B
	                    except
	                    select * from @A) then 1 else 0 end

SELECT CASE WHEN EXISTS
(
SELECT 
			1
FROM 
			(SELECT k=1, * FROM @A) a
				LEFT OUTER JOIN 
					(SELECT k=1, * FROM @B) b
						ON a.i=b.j
GROUP BY 
			a.k
HAVING 
			COUNT(a.i)=(SELECT COUNT(*) FROM @B)
			AND 
			COUNT(a.i)=COUNT(b.j)
) THEN 1 ELSE 0 END

quote:

---

Originally posted by ms65g

I am waiting still!

---