TSQL - call stored proc

• pzmrcd

  Default port

  Points: 1419

  More actions

  July 23, 2008 at 12:16 pm

  #381876

  Hi

  I am writing a stored proc. I have declared a var inside the sproc.

  DECLARE @recipients varchar(100)

  Now I am trying to populate this with the output of another sproc.

  SELECT @recipients = 'exec '+ 'sp_Getmail ' + 'xyz'

  This is not working..any suggestions.

  Thanks

• wmt

  SSChasing Mays

  Points: 602

  More actions

  July 23, 2008 at 12:39 pm

  #847296

  What error do you receive? Is it a syntax one?

  I would tend to do this:

  DECLARE @recipients varchar(100)

  exec sp_Getmail 'xyz', @recipients OUT

  SELECT @recipients

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  July 23, 2008 at 12:40 pm

  #847297

  Hi

  If I want to set the return value of a stored procedure to a variable, this is how I would do

  declare @int as int

  Exec @int = uspGetEmployeeManagers 12

  PRINT @int

  If I want to set the output parameter of a stored procedure, this is how I would do,

  declare @int as int

  Exec sp_storedProcedwithoutparam @int output

  PRINT @int

  I am not sure if this answers your question 🙂

  Pakki

  ---------------------------------------------------------------------------------