Forum Replies Created

Viewing 15 posts - 3,856 through 3,870 (of 8,761 total)

  • RE: Are the posted questions getting worse?

    Sean Lange (2/15/2016)


    Grant Fritchey (2/15/2016)


    Hugo Kornelis (2/15/2016)


    jasona.work (2/15/2016)


    So, a question for everyone:

    How do you feel if someone comes back and tells you that they tested a solution you provided before...

  • RE: XML PATH QUESTION

    Lynn Pettis (2/15/2016)


    Eirikur Eiriksson (2/15/2016)


    Luis Cazares (2/15/2016)


    Eirikur Eiriksson (2/15/2016)


    Luis Cazares (2/15/2016)


    Eirikur,

    Any reason for using FLOOR on an integer division?

    Old oracle habit

    😎

    :sick:Oracle:sick:

    yup, the difference between \ and / :pinch:

    😎

    We got you...

  • RE: XML PATH QUESTION

    Luis Cazares (2/15/2016)


    Eirikur Eiriksson (2/15/2016)


    Luis Cazares (2/15/2016)


    Eirikur,

    Any reason for using FLOOR on an integer division?

    Old oracle habit

    😎

    :sick:Oracle:sick:

    yup, the difference between \ and / :pinch:

    😎

  • RE: XML PATH QUESTION

    Luis Cazares (2/15/2016)


    Eirikur,

    Any reason for using FLOOR on an integer division?

    Old oracle habit

    😎

  • RE: XML PATH QUESTION

    koti.raavi (2/15/2016)


    Hi to all,

    I have got a one column in table containing different Client ID's. There are 3000 rows in a table ...I need a data with comma separated(each row...

  • RE: How do we get the definition of tables via sql

    Phil Parkin (2/12/2016)


    Grumpy DBA (2/12/2016)


    "Give a man a fish and he eats for a day. Teach a man how to fish and he eats for a lifetime."

    I believe Brandie...

  • RE: How do we get the definition of tables via sql

    Quick and simple suggestion, encapsulate the SMO in a CLR.

    😎

  • RE: Adding quotes to dynamic SQL

    Slightly longer suggestion here

    😎

  • RE: Adding quotes to dynamic SQL

    Short suggestion, CHAR(39)

    😎

  • RE: Are the posted questions getting worse?

    Sean Lange (2/8/2016)


    Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time in...

  • RE: Are the posted questions getting worse?

    SQLRNNR (2/8/2016)


    So, who showed up to SQLSat Cleveland as Mimi?

    It sounds like Wayne chickened out. He should get flying porkchops for that.

    Wayne does not chicken out, he turkeys out:-D

    😎

    There is...

  • RE: How to get minimum date of an ID with respect to startdate?

    Quick suggestion

    😎

    DECLARE @A TABLE (ID int, StartDate datetime)

    DECLARE @b-2 TABLE (ID int, StartDate datetime)

    INSERT INTO @b-2

    SELECT 1,GETDATE()-5 UNION ALL

    SELECT 1,GETDATE()-7 UNION ALL

    SELECT 2,GETDATE()-8 ...

  • RE: Are the posted questions getting worse?

    WayneS (2/4/2016)


    Eirikur Eiriksson (2/4/2016)


    This was Alex demonstrating DLM & CI, did an impressive job, must add that I removed the bad practice comment from the screenshot ( for fun)

    I...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/4/2016)


    Steve Jones - SSC Editor (2/4/2016)


    I'm sure that's my presentation...

    where I fix Grant's code.

    Ha! Love you too!

    I have to go back and tune his "fixes" later so...

    You mean...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (2/4/2016)


    Grant Fritchey (2/4/2016)


    Eirikur Eiriksson (2/4/2016)


    For fun (screenshot from a RedGate presentation)

    😎

    Why do you think I'm working on that database?

    Ha!

    I'm pretty sure that's one of...

Viewing 15 posts - 3,856 through 3,870 (of 8,761 total)