Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Stairway to Biml Level 5 - Biml Language Elements

    Thanks for the quick reply, Reeves! This is great!

    I have a few other small Biml questions, if you don’t mind:

    1.Can you use Biml to create SSRS reports?

    2.What version of...

  • RE: Stairway to Biml Level 5 - Biml Language Elements

    This was an excellent walkthrough. But I have a question: If you have a Biml file with BimlScript in it, is there any way to see the Biml...

  • RE: Concatenating Rows

    Actually, I just realized that doing it for multiple columns is as easy as adding another FOR XML (and including a DISTINCT to prevent dups):

    with produce (id,fruit,city)

    as (

    SELECT 101,'Apple','Cleveland'

    UNION ALL...

  • RE: Concatenating Rows

    Much thanks, Adam Haines, for the XMl rollup example.

    Any way to get it for multiple columns? As in raw data:








    results in:

    101 'Apple, Banana', 'Cleveland, Pittsburgh'

    102 'Grape, Melon', 'Cleveland'

    103 'Melon',...

  • RE: Concatenating Rows

    (haven't read through all the posts; sorry if someone already has this)

    I've modified so that there is aggregation to an ID:

    IF EXISTS (SELECT * FROM sys.objects

    WHERE object_id...

  • RE: Concatenating Rows

    What about if you had rows that you wanted to aggregate like this:


    101 Apple

    101 Banana

    102 Orange

    102 Melon

    102 Grape

    And wanted a result set like:


    101 Apple,...

Viewing 6 posts - 1 through 6 (of 6 total)