HOw to get

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  November 14, 2009 at 12:33 am

  #212293

  HI

  DECLARE @t Table (t int)

  insert into @t values(1)

  insert into @t values(2)

  insert into @t values(3)

  insert into @t values(4)

  insert into @t values(5)

  insert into @t values(6)

  DECLARE @t1 Table (r int,c int )

  insert into @t1 values(2,2)

  insert into @t1 values(3,4)

  insert into @t1 values(6,6)

  SELECT * FROM @t

  SELECT * FROM @t1

  i need 1,5 as output which is not in second table

  Thanks

  Parthi

  Thanks
  Parthi

• arun.sas

  SSChampion

  Points: 11831

  More actions

  November 14, 2009 at 1:16 am

  #1079331

  select t from

  (select t,r,c

  from @t left join @t1

  on t = r

  or t = c) as x

  where r is null

  and c is null

• Paul White

  SSC Guru

  Points: 150467

  More actions

  November 14, 2009 at 7:37 am

  #1079365

  SELECT t

  FROM @t

  WHERE NOT EXISTS

  (

  SELECT *

  FROM @t1

  WHERE t IN (r,c)

  );

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi