Forum Replies Created

Viewing 15 posts - 451 through 465 (of 844 total)

  • RE: Question Regarding Date logic

    This should have been:
    " I would though guess that half the developers at my current shop and more than half at my prior shop wouldn't understand or follow the tally...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 23, 2018 at 7:51 am

    #1976907

  • RE: Question Regarding Date logic

    ChrisM@Work - Tuesday, January 23, 2018 1:23 AM

    below86 - Monday, January 22, 2018 10:58 AM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 23, 2018 at 7:47 am

    #1976904

  • RE: Question Regarding Date logic

    Jeff Moden - Monday, January 22, 2018 7:07 PM

    below86 - Monday, January 22, 2018 12:49 PM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 23, 2018 at 7:44 am

    #1976901

  • RE: Question Regarding Date logic

    drew.allen - Monday, January 22, 2018 1:25 PM

    below86 - Monday, January 22, 2018 1:16 PM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 22, 2018 at 1:43 pm

    #1976808

  • RE: Question Regarding Date logic

    ScottPletcher - Monday, January 22, 2018 1:05 PM

    below86 - Monday, January 22, 2018 12:49 PM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 22, 2018 at 1:16 pm

    #1976797

  • RE: Question Regarding Date logic

    I would say using 0 to represent 01-01-1900 or -1 to mean 12-31-1899 is far more 'tricky' of code than coding a loop.  Coding a loop is (has been for...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 22, 2018 at 12:49 pm

    #1976792

  • RE: Question Regarding Date logic

    In a follow up post KGJ-dev wanted to be able to pass any number of months.  That's why I tried each for more than 24.

    In my testing:
    ChrisM's...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 22, 2018 at 10:58 am

    #1976765

  • RE: Question Regarding Date logic

    drew.allen - Monday, January 22, 2018 9:54 AM

    below86 - Monday, January 22, 2018 9:48 AM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 22, 2018 at 10:00 am

    #1976759

  • RE: Question Regarding Date logic

    This may be 'the long way around the barn', but it works.  You could set this up a a SP and pass it the number of months you want and...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 22, 2018 at 9:48 am

    #1976757

  • RE: Question Regarding Date logic

    drew.allen - Friday, January 19, 2018 11:57 AM

    KGJ-Dev - Friday, January 19, 2018 11:23 AM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 19, 2018 at 12:35 pm

    #1976571

  • RE: How do you store and retrieve useful scripts?

    mike.dinnis - Thursday, January 4, 2018 8:08 AM

    @below86, that's a nice simple solution which I think I can make use of in...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 4, 2018 at 10:29 am

    #1974499

  • RE: How do you store and retrieve useful scripts?

    I've been using OneNote, I created a section to hold all of these scripts.  Each script is on a separate page within the section, I try to give each page...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 4, 2018 at 7:38 am

    #1974455

  • RE: Only show the latest date in a selection of data

    You should be able to use the MAX to get what you want, unless I'm not understanding your issue.

    DECLARE @sample TABLE
    (
        ContactID INT,
        RenewalDate...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    January 2, 2018 at 10:08 am

    #1974101

  • RE: SQL Battleship

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    December 8, 2017 at 1:34 pm

    #1971429

  • RE: SQL Battleship

    OMG, the game of my life.  The first 6 shots I had I sank the sub and destroyer.  Took 8 more shots to get the Aircraft carrier, then 7 more...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

    December 8, 2017 at 1:31 pm

    #1971428

Viewing 15 posts - 451 through 465 (of 844 total)