setting multiple variables in one line

• rodneyp

  SSC Enthusiast

  Points: 103

  More actions

  April 12, 2002 at 6:59 am

  #77972

  I am migrating from Sybase and am trying to replicate the functionality of the following in one line without using multiple select @variable = ... statements or opening a cursor

  Select Col1, Col2, Col3 ... From Table into @var1, @var2, @var3 ...

  Any help would be appreciated.

• Eve

  SSCrazy

  Points: 2480

  More actions

  April 12, 2002 at 7:42 am

  #427107

  Select @var1 =Col1, @var2 =Col2, @var3 = Col3

  From mytable

  Where ....

  For the Cursor:

  declare MyCURSOR cursor

  for Select Col1, Col2, Col3

  from mytable

  open MyCursor

  set nocount on

  fetch next from MyCursor into

  @var1, @var2, @var3

  while @@fetch_status = 0

  begin

  Do Somthing

  fetch next from MyCursor into

  @var1, @var2, @var3

  end

  close MyCursor

  deallocate MyCursor

  Good Luck!

  Edited by - EPol29 on 04/12/2002 07:45:04 AM

• rodneyp

  SSC Enthusiast

  Points: 103

  More actions

  April 12, 2002 at 9:11 am

  #427121

  Thank you very much