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...

    May 20, 2016 at 10:38 am

    #1880546

  • 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

    May 20, 2016 at 10:28 am

    #1880544

  • 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...

    May 20, 2016 at 10:27 am

    #1880542

  • 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...

    May 20, 2016 at 8:01 am

    #1880494

  • 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(

    ...

    May 20, 2016 at 7:36 am

    #1880485

  • RE: SUM()

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

    May 20, 2016 at 7:32 am

    #1880482

  • 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...

    May 20, 2016 at 5:45 am

    #1880457

  • 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

    May 19, 2016 at 10:55 am

    #1880311

  • 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

    May 19, 2016 at 10:37 am

    #1880305

  • 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

    May 19, 2016 at 6:35 am

    #1880172

  • 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

    May 19, 2016 at 5:34 am

    #1880141

  • RE: Today's Random Word!

    Grumpy DBA (5/19/2016)

    djj (5/19/2016)

    Shooter

    Oswald

    Ruby

    May 19, 2016 at 5:16 am

    #1880136

  • 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

    May 18, 2016 at 1:18 pm

    #1880009

  • 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...

    May 18, 2016 at 1:18 pm

    #1880008

  • 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...

    May 18, 2016 at 12:15 pm

    #1879956

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