Assigning values to multiple variables with single SELECT (with a twist)

• Evil Kraig F

  SSC Guru

  Points: 100851

  More actions

  January 11, 2011 at 11:24 am

  #1272005

  GSquared (1/11/2011)

  ---

  Jeff Moden (1/10/2011)

  ---

  WayneS (1/10/2011)

  ---

  Craig Farrell (1/10/2011)

  ---

  GSquared (1/10/2011)

  ---

  Since you're using SQL 2008, can you switch from delimited lists of parameter values to a table variable parameter? Those are more efficient.

  I haven't had the opportunity to use them at a business level yet, but they're dang handy.

  Sounds like a "SQL Spackle" opportunity for someone... :w00t:

  Agreed... Gus? What say thee?

  I have used them in a business environment, and they worked great. I'll see what I can write up on it.

  I will duck out, stage left, then. I still need to get SQL 2k8 express installed at home.

  ---

  - Craig Farrell

  Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

  For better assistance in answering your questions[/url] | Forum Netiquette
  For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
  Twitter: @AnyWayDBA