except

• coool_sweet

  SSCommitted

  Points: 1892

  More actions

  July 17, 2017 at 9:08 pm

  #402318

  hi

  i want to do something like this, is it possible?if not what other option

  EXECUTE sp_executesql @emp

  except

  EXECUTE sp_executesql @dept

  both emp and dept has select statement,with same number of columns

• DesNorton

  SSC-Insane

  Points: 24448

  More actions

  July 17, 2017 at 10:23 pm

  #1951306

  coool_sweet - Monday, July 17, 2017 9:08 PM

  hi

  i want to do something like this, is it possible?if not what other option

  EXECUTE sp_executesql @emp

  except

  EXECUTE sp_executesql @dept

  both emp and dept has select statement,with same number of columns

  Try something like this
  

  CREATE TABLE #emp (...);
INSERT INTO #emp (...)
EXECUTE sp_executesql @emp;

  CREATE TABLE #dept (...);
INSERT INTO #dept (...)
EXECUTE sp_executesql @dept;

  SELECT * FROM #emp
EXCEPT
SELECT * FROM #dept

  ---

  How to post data/code on a forum to get the best help.

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  July 18, 2017 at 1:46 pm

  #1951498

  Does this work?
  
  DECLARE @sql nvarchar(max) = @emp +N'
   EXCEPT
  '+@dept;
  EXEC sp_ExcueSQL @sql;

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 18, 2017 at 1:50 pm

  #1951499

  coool_sweet - Monday, July 17, 2017 9:08 PM

  hi

  i want to do something like this, is it possible?if not what other option

  EXECUTE sp_executesql @emp

  except

  EXECUTE sp_executesql @dept

  both emp and dept has select statement,with same number of columns

  First, no.  You have to put the data into tables first.  Second, without seeing what the output from each of the procedures looks like, just because they have the same number of columns doesn't mean that the EXCEPT makes any sense.