select the output of stored procedure with count of returned rows

• Ali.M.Habib

  SSC Eights!

  Points: 930

  More actions

  May 4, 2013 at 12:52 am

  #292928

  I want to select the output of stored procedure and the count of the row affected

  So am trying to do something like that

  select * , count(*)

  (

  if @checker is not null

  begin

  exec [dbo].[GetEmployees]

  @parameter1,

  @parameter2

  end

  else

  begin

  exec [dbo].[GetEmployees]

  @parameter3,

  @parameter4

  end

  )T

  I always get error like this

  Incorrect syntax near the keyword 'if'.

  Incorrect syntax near ')'.

• brad.mason5

  Hall of Fame

  Points: 3299

  More actions

  May 4, 2013 at 1:41 am

  #1612369

  ok so you are trying to execute stored proc inside join. Also the IF statement should be outside.

  If you can get the date from this stored proc and then count the records.

  I am not sure the data set returned but you can.

  IF @checker is not null

  BEGIN

  INSERT INTO #temp

  (

  column1

  ,column2

  ,....

  exec [dbo].[GetEmployees]

  @parameter1,

  @parameter2

  END

  ELSE

  BEGIN

  INSERT INTO #temp

  (

  column1

  ,column2

  ,....

  exec [dbo].[GetEmployees]

  @parameter3,

  @parameter4

  END