title: TSQL - efficient way of setting multiple variables
body: <p>is their a more efficient way of doing this?</p>
  
  <pre><code>set @ShippingL = (select ShippingL from AuctionProducts where ProductID = @ProductID)
  set @ShippingB = (select ShippingB from AuctionProducts where ProductID = @ProductID)
  set @ShippingH = (select ShippingH from AuctionProducts where ProductID = @ProductID)
  set @ShippingW = (select ShippingW from AuctionProducts where ProductID = @ProductID)
  </code></pre>
  
  <p>Cheers,
  -R</p>