Storing query results in sp local variables

• mick L

  SSCommitted

  Points: 1526

  More actions

  March 20, 2003 at 3:50 am

  #158978

  Folks,

  If i need to store the results of a query in local variables like..

  set @product =(select product_name from products where product_id = @id)

  set @product_type = (select product_type from products where product_id = @id)

  How can I set more that one local variable to a query value at once.

  Cheers

  Mick

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  March 20, 2003 at 5:11 am

  #451543

  select @a = a, @b-2 = b from table

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• mick L

  SSCommitted

  Points: 1526

  More actions

  March 20, 2003 at 5:49 am

  #451544

  That easy!

  Thanks Chris