Assigning Multiple Variables

• beath

  SSCrazy

  Points: 2939

  More actions

  June 14, 2004 at 3:24 am

  #111560

  I want to assign multiple variables using a single  select statement. For example:

  DECLARE @var1 varchar(10)

  DECLARE @var2 varchar(10)

  SELECT col1, col2 into @var1, @var2 from table where....

  Can you do this sort of thing in 1 statement? What's the quickest way without resorting to loops, cursors, or temp tables?

   

  cheers

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 14, 2004 at 4:15 am

  #510231

  Select @var1=col1, @var2=col2 from table where....

  HTH

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass