Forum Replies Created

Viewing 15 posts - 3,346 through 3,360 (of 8,731 total)

  • RE: Today's Random Word!

    djj (2/16/2016)

    crookj (2/16/2016)

    Luis Cazares (2/16/2016)

    DonlSimpson (2/16/2016)

    Ed Wagner (2/15/2016)

    Revenant (2/15/2016)

    Luis Cazares (2/15/2016)

    HappyGeek (2/15/2016)

    Adam

    Eve

    Lilith

    Isaiah

    Thomas

    Wayne

    Bruce

    Robin

    Nightwing

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 12:25 pm

    #1859071

  • RE: SQL Query to Extract after 2nd - in a field

    trvlbabie (2/16/2016)

    When I add the line: SUBSTRING(String, 10, 5)

    It is giving me the following error: SQL API: [SQLExecDirectW], SQL RETURN: [-1], SQL STATE: [42000], SQL NATIVE ERROR:...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 12:24 pm

    #1859070

  • RE: Datetime Parameter Default

    Just another option.

    SELECT

    StartTime = DATEADD(HH,-6,CAST(CAST(GETDATE() AS date) AS datetime)), -- 6PM yesterday

    EndTime = DATEADD(HH,6,CAST(CAST(GETDATE() AS date) AS datetime)); -- 6AM today

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 11:25 am

    #1859049

  • RE: SQL Query to Extract after 2nd - in a field

    You have several options. You can play with substring and charindex if the first items have variable lengths, or you could split the whole string and take the part you...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 11:05 am

    #1859045

  • RE: Datetime Parameter Default

    For this particular case, there's a simpler solution using common date routines[/url]

    SELECT

    StartTime = DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), -.25), -- 6PM yesterday

    EndTime =...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 10:49 am

    #1859040

  • RE: Are the posted questions getting worse?

    ChrisM@Work (2/16/2016)

    SQLRNNR (2/16/2016)

    jasona.work (2/16/2016)

    GilaMonster (2/16/2016)

    Cthulhu for president! Why vote for the lesser evil?

    I'm leaning towards the Palpatine / Vader ticket myself...

    Or if they don't make it, Bill and Opus...

    (I refuse...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 10:38 am

    #1859035

  • RE: Stored procedure terminated

    ripas (2/16/2016)

    Hello,

    I am trying to run one stored procedure and it failed to run. And I got this error message when I was trying to execute. How could I solve...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 10:34 am

    #1859033

  • RE: Today's Random Word!

    DonlSimpson (2/16/2016)

    Ed Wagner (2/15/2016)

    Revenant (2/15/2016)

    Luis Cazares (2/15/2016)

    HappyGeek (2/15/2016)

    Adam

    Eve

    Lilith

    Isaiah

    Thomas

    Wayne

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 10:05 am

    #1859027

  • RE: ROW_NUMBER() function with a difference

    My suggestion is something that should be tested really carefully. It involves a technique called Quirky Update which is very fast but unreliable when not done properly. All the information...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 9:12 am

    #1859011

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/16/2016)

    The real problem is that those that govern have forgotten who are the masters and who are the servants. Government is supposed to the servants of the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 8:54 am

    #1859003

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (2/16/2016)

    GilaMonster (2/16/2016)

    Hugo Kornelis (2/16/2016)

    Oh, I am not laughing. Not at all. I am concerned and bewildered. Mostly concerned.

    Likewise. With a side of terrified that one of the buffoons...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 16, 2016 at 7:50 am

    #1858983

  • RE: Today's Random Word!

    HappyGeek (2/15/2016)

    Adam

    Eve

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 15, 2016 at 12:28 pm

    #1858837

  • RE: SSIS Error Temp tables

    SSIS won't work with temp tables. I'm not sure if table variables are an option or will cause the same error. The safest way is to create perm tables in...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 15, 2016 at 12:09 pm

    #1858836

  • RE: XML PATH QUESTION

    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:

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 15, 2016 at 10:24 am

    #1858820

  • RE: XML PATH QUESTION

    Eirikur,

    Any reason for using FLOOR on an integer division?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 15, 2016 at 8:36 am

    #1858795

Viewing 15 posts - 3,346 through 3,360 (of 8,731 total)