SQL Query Help after 13th row Dynamic and in 12th row static values with a formula

  • Hey JJ,

    Sorry it's late and I'm glad you found your solution.

    What we were trying to get out of you was something like this, which if you'd read the article end to end you'd have realized:

    CREATE TABLE testtable (columna VARCHAR(10) NOT NULL)

    INSERT INTO testtable (columna)

    SELECT 'abc' UNION ALL

    SELECT 'def' UNION ALL

    SELECT 'ghi'

    --- Desired result to look like:

    abc,def,ghi

    I know you're frustrated and trying to find a solution, but that kind of thing helps us give you tested code that works exactly as you've asked for. We can lead you down a lot of long, un-useful roads if you don't provide that.


    - 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