execute insert query

• esqared7

  SSC Veteran

  Points: 251

  More actions

  April 10, 2003 at 7:19 am

  #79832

  Hi

  In my stored procedure I have a select query which gives me a number as a select, example

  'Select days from service where cid = 1', where days is the integer number.

  Now for this value(days) I want to execute a insert query into another table.

  means if days is 3 I will execute that same insert query 3 times.

  How do I take care of this in my stored procedure.

  Thanks

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  April 10, 2003 at 7:39 am

  #453712

  One way is:

  declare @count tinyint, @days tinyint

  select @days = days

  from service

  where cds = 1

  set @count = 1

  while @count <= <number of days> begin

  /* Insert statements in here */

  set @count = @count + 1

  end

  This will loop once for each number of days.

  Jeremy