Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 9,399 total)

  • RE: Are the posted questions getting worse?

    Luis Cazares (5/20/2016)


    Tomorrow there's a SQL Saturday in Atlanta and I can't attend. I'll miss the opportunity to meet Jason B and Wayne S.

    I'll probably have to wait for next...

  • RE: Today's Random Word!

    crookj (5/20/2016)


    djj (5/20/2016)


    Manic Star (5/20/2016)


    Ray K (5/20/2016)


    Manic Star (5/20/2016)


    Beautiful (75 and partly cloudy)

    Ugly

    Duckling

    Quack

    Doctor

    Demento

    Shoes

  • RE: Split Delimited String Across Fixed Number Of Columns

    Luis Cazares (5/20/2016)


    Ed Wagner (5/20/2016)


    Luis Cazares (5/20/2016)


    Ed Wagner (5/20/2016)


    You have to love the dynamic crosstab. Nice work, Luis.

    Thank you, Alan.

    This has become simpler each time. It's even better now...

  • RE: Split Delimited String Across Fixed Number Of Columns

    Luis Cazares (5/20/2016)


    Ed Wagner (5/20/2016)


    You have to love the dynamic crosstab. Nice work, Luis.

    Thank you, Alan.

    This has become simpler each time. It's even better now that I have templates...

  • RE: Split Delimited String Across Fixed Number Of Columns

    Luis Cazares (5/20/2016)


    I wouldn't want to write 99 columns, so I would use a dynamic approach for this.

    DECLARE @sql nvarchar(max);

    WITH

    E(n) AS(

    SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

    ),

    cteTally(n) AS(

    ...

  • RE: SUM()

    A great question to illustrate the concept of the "presence of rows" instead of the content of the row.

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (5/20/2016)


    So...

    Installing our new prod servers. Was doing swimmingly until I got to the Add Node to Cluster. Got to the account / password page of the install and...

  • RE: Today's Random Word!

    Alan.B (5/19/2016)


    Revenant (5/19/2016)


    Ed Wagner (5/19/2016)


    Alan.B (5/19/2016)


    ThomasRushton (5/19/2016)


    djj (5/19/2016)


    crookj (5/19/2016)


    Ed Wagner (5/19/2016)


    Alan.B (5/19/2016)


    ThomasRushton (5/19/2016)


    Ed Wagner (5/19/2016)


    BWFC (5/19/2016)


    Ed Wagner (5/19/2016)


    Grumpy DBA (5/19/2016)


    djj (5/19/2016)


    Shooter

    Oswald

    Ruby

    Tuesday

    Friday

    Tomorrow

    Tomato

    Sauce

    BBQ

    Meat

    Feast

    Fast

    Slow

    Burn

    Out

    Outside

  • RE: Today's Random Word!

    Alan.B (5/19/2016)


    ThomasRushton (5/19/2016)


    djj (5/19/2016)


    crookj (5/19/2016)


    Ed Wagner (5/19/2016)


    Alan.B (5/19/2016)


    ThomasRushton (5/19/2016)


    Ed Wagner (5/19/2016)


    BWFC (5/19/2016)


    Ed Wagner (5/19/2016)


    Grumpy DBA (5/19/2016)


    djj (5/19/2016)


    Shooter

    Oswald

    Ruby

    Tuesday

    Friday

    Tomorrow

    Tomato

    Sauce

    BBQ

    Meat

    Feast

    Fast

    Slow

  • RE: Today's Random Word!

    Alan.B (5/19/2016)


    ThomasRushton (5/19/2016)


    Ed Wagner (5/19/2016)


    BWFC (5/19/2016)


    Ed Wagner (5/19/2016)


    Grumpy DBA (5/19/2016)


    djj (5/19/2016)


    Shooter

    Oswald

    Ruby

    Tuesday

    Friday

    Tomorrow

    Tomato

    Sauce

  • RE: Today's Random Word!

    BWFC (5/19/2016)


    Ed Wagner (5/19/2016)


    Grumpy DBA (5/19/2016)


    djj (5/19/2016)


    Shooter

    Oswald

    Ruby

    Tuesday

    Friday

  • RE: Today's Random Word!

    Grumpy DBA (5/19/2016)


    djj (5/19/2016)


    Shooter

    Oswald

    Ruby

  • RE: Today's Random Word!

    Manic Star (5/18/2016)


    crookj (5/18/2016)


    Ray K (5/18/2016)


    djj (5/18/2016)


    BWFC (5/18/2016)


    Ray K (5/18/2016)


    Ed Wagner (5/18/2016)


    f-society

    f-this

    f-stop

    f-sharp

    f-flat (=E)

    F-Troop (sorry I am late on this one...)

    honor roll

    Deans List

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/18/2016)


    Lynn Pettis (5/18/2016)


    J Livingston SQL (5/18/2016)


    Lynn Pettis (5/18/2016)


    J Livingston SQL (5/18/2016)


    Lynn Pettis (5/18/2016)


    Grumpy DBA (5/18/2016)


    jasona.work (5/18/2016)


    Brandie Tarvin (5/18/2016)


    Oh, my. SS just rebuked someone for asking what SS thinks...

  • RE: Are the posted questions getting worse?

    jasona.work (5/18/2016)


    Brandie Tarvin (5/18/2016)


    Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question. And in this case it probably is, but SS is the last...

Viewing 15 posts - 3,136 through 3,150 (of 9,399 total)