Forum Replies Created

Viewing 15 posts - 841 through 855 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Tuesday, November 14, 2017 11:51 AM

    Just a short update.  My dad ended up being moved to ICU due to...

    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

    November 14, 2017 at 12:24 pm

    #1968070

  • RE: Should this index be clustered?

    Lynn Pettis - Tuesday, November 14, 2017 12:00 PM

    Not sure what you mean by duplication of data, unless you mean that...

    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

    November 14, 2017 at 12:18 pm

    #1968069

  • RE: Delete syntax not working

    sgmunson - Tuesday, November 14, 2017 9:20 AM

    John N Hick - Tuesday, November 14, 2017 9:12 AM

    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

    November 14, 2017 at 10:19 am

    #1968036

  • RE: Are the posted questions getting worse?

    Jeff Moden - Monday, November 13, 2017 12:58 PM

    Ugh!  That's a huge sore spot with me.  I remember when I first...

    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

    November 13, 2017 at 2:24 pm

    #1967871

  • RE: Delete syntax not working

    nigel. - Monday, November 13, 2017 1:34 AM

    Hmm... looks like the OP has been scared away by all this talk of ISO...

    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

    November 13, 2017 at 9:17 am

    #1967811

  • RE: exec (@sp) running twice

    What about something like this?

    DECLARE @sp-2 nvarchar(max)
    DECLARE @RunID INT
    SET @RunID = (SELECT MAX(RunID) as RunID FROM [RISE].[dbo].[tb_CompaniesToRun])

    -----------------------------------------------------------------------------------------------
    ------------------- EXECUTE ALL THE STORED...

    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

    November 10, 2017 at 9:36 am

    #1967550

  • RE: Is it a duplicate Index?

    Grant Fritchey - Thursday, November 9, 2017 6:43 AM

    anthony.green - Thursday, November 9, 2017 1:36 AM

    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

    November 9, 2017 at 7:35 am

    #1967370

  • RE: Dynamic Pivot/Unpivot

    psobanski - Wednesday, November 8, 2017 10:02 AM

    Luis Cazares - Wednesday, November 8, 2017 7:47 AM

    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

    November 8, 2017 at 10:06 am

    #1967202

  • RE: Are the posted questions getting worse?

    Sean Lange - Wednesday, November 8, 2017 7:19 AM

     And one line per column in the code please. 🙂

    I'd say one column...

    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

    November 8, 2017 at 7:59 am

    #1967168

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Wednesday, November 8, 2017 5:42 AM

    Grant Fritchey - Wednesday, November 8, 2017 5:33 AM

    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

    November 8, 2017 at 7:52 am

    #1967166

  • RE: Dynamic Pivot/Unpivot

    Some small improvements to Thomas' code. Even with dynamic code, I like to keep it with a good format to ease the debugging.
    I'm also using sp_executesql which would allow...

    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

    November 8, 2017 at 7:47 am

    #1967164

  • RE: Dynamic Pivot/Unpivot

    psobanski - Tuesday, November 7, 2017 3:12 AM

    Hello, 
    I have a table like below, where headers of columns and rows are dynamic (this...

    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

    November 7, 2017 at 10:02 am

    #1967019

  • RE: Listing records based on condition

    drew.allen - Monday, November 6, 2017 2:36 PM

    Here is another approach.  My initial testing indicates that it should be faster.


    WITH...

    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

    November 7, 2017 at 7:57 am

    #1966999

  • RE: Date Ranges - Simple, but seemingly impossible

    sgmunson - Monday, November 6, 2017 2:44 PM

    Don't you want (1 - Discount1) instead of (-1 + Discount1) ?   This would...

    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

    November 6, 2017 at 2:48 pm

    #1966893

  • RE: Date Ranges - Simple, but seemingly impossible

    What about something like this to avoid creating more rows?

    CREATE TABLE ProductDiscounts (
    Stack VARCHAR (255),
    ProductCode VARCHAR (255),
    ValidFrom DATE,
    ValidTo DATE,
    Discount1 decimal(4,3));

    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

    November 6, 2017 at 1:24 pm

    #1966878

Viewing 15 posts - 841 through 855 (of 8,731 total)