Execute Multiple Exec Command in a string

• jj011185

  Old Hand

  Points: 324

  More actions

  May 6, 2009 at 12:22 am

  #133846

  Hi all,

  I have a store procedure that generates this dynamic output

  Execute generate_email '1'; Execute generate_email '9';

  which i would like to execute them in at once. how do you do this?

  I am trying to avoid cursor here so I tried going into concatenating all those execute statements into a string and execute them at the same time. is this possible?

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  May 6, 2009 at 4:46 am

  #989413

  Hi

  I'm not sure if I got you, but try this:

  CREATE PROCEDURE usp_TestPrint

  @text NVARCHAR(128)

  AS

  PRINT @text

  GO

  DECLARE @sql NVARCHAR(MAX)

  SELECT TOP(10)

  @sql = ISNULL(@sql, '') + CHAR(10) + N'EXECUTE usp_TestPrint ''' + name + ''''

  FROM sys.objects

  EXECUTE (@sql)

  Greets

  Flo

• arun.sas

  SSChampion

  Points: 11831

  More actions

  May 6, 2009 at 5:09 am

  #989425

  Hi,

  try this

  DECLARE @abc VARCHAR(1000)

  SELECT @abc = 'SELECT * FROM syssegments; SELECT * FROM sysconstraints;'

  select @abc = replace(@abc,';',' GO')

  exec (@abc)

  ARUN SAS