Stored procedures within cursor

• Sql Student-446896

  Default port

  Points: 1425

  More actions

  September 4, 2009 at 10:30 am

  #73892

  Hi,

  I have a cursor declared for some columns from a table. The values of the cursor is the input paramater of the stored procedure.

  I need to include another stored procedure which takes a different combination from the cursor.

  Eg:

  open cur

  Fetch

  @name

  @id

  Exec SP1 @name, @id -- @name = 'Ab01'

  EXEC SP2 @name, @id -- @name = 'ka01'

  How to include the 2 SP's with conditions on @name value?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  September 4, 2009 at 11:09 am

  #1049532

  It looks, from your example, like @name is supposed to have two different values. Is that what you're trying to accomplish?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon