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

  • 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

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply