Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 6,036 total)

  • RE: t-sql 2012 self joins

    I know what EAV is good for.

    A search.

    A search for value in one of the field.

    Instead of building one of those "catch all" queries store all the values in an...

    February 2, 2016 at 10:14 pm

    #1856165

  • RE: RECREATE AN ID OF A ROW AFTER BEING DELETED

    JustMarie (1/25/2016)

    The ONLY business reason I can think of for this situation is a legal requirement that there be no gaps in the numbering. There's a vague memory of...

    February 2, 2016 at 3:22 pm

    #1856136

  • RE: Need help related to index

    Hugo Kornelis (2/1/2016)

    The clustered index should always be created before loading

    And usually (well, that word - "usually" 🙂 ) a perfect candidate for a clustered PK on a staging table...

    February 2, 2016 at 2:31 pm

    #1856124

  • RE: Flag Values Based on Columns

    MMartin1 (2/2/2016)

    This data could be pre-sorted elsewhere (like in Excel) imported, and the user is only interested in the columns presented to us (not the sort column). In the case...

    February 2, 2016 at 1:49 pm

    #1856115

  • RE: Flag Values Based on Columns

    Eirikur Eiriksson (1/27/2016)

    But it is kind of disappointing when the structure of the solution is there and no one pitches in the final bit.

    😎

    Only thing which was there was a...

    February 1, 2016 at 7:33 pm

    #1855893

  • RE: Date Function

    ScottPletcher (1/25/2016)

    Sergiy (1/25/2016)

    MMartin1 (1/25/2016)

    No, since this particular statement is vague the best we can do is start him off with some basics to try and get more information. This is...

    January 25, 2016 at 1:11 pm

    #1854281

  • RE: Date Function

    MMartin1 (1/25/2016)

    No, since this particular statement is vague the best we can do is start him off with some basics to try and get more information. This is not wrong,...

    January 25, 2016 at 11:15 am

    #1854242

  • RE: Finding Stored Procedures

    Actually, none of the answers is correct.

    As it was mentioned, INFORMATION_SCHEMA.ROUTINES lists not only procedures but functions as well. Without a filtering ROUTINE_TYPE in the query - it's not a...

    January 24, 2016 at 9:19 pm

    #1854084

  • RE: Date Function

    I think he was not totally understanding date math in sql server. Once he defined the problem better Scott was able to give him a solution. I was thrown...

    January 23, 2016 at 12:03 am

    #1853981

  • RE: Flag Values Based on Columns

    Jeff Moden (1/21/2016)

    nm.rajesh (1/17/2016)

    Thanks a lot 🙂

    See my post above. Unless the guarantees that I stated above are enforced by constraints and then the a_m column is brought into...

    January 21, 2016 at 6:59 pm

    #1853684

  • RE: Flag Values Based on Columns

    Hugo Kornelis (1/21/2016)

    Hey, here's another idea.

    Instead of bashing people who at least attempted to help the OP, why don't you chime in with your solution to the problem? For me,...

    January 21, 2016 at 5:09 pm

    #1853677

  • RE: Flag Values Based on Columns

    MMartin1 (1/21/2016)

    You assume a bit much though. The OP might have a situation where he needs to deliver a result now, and take care of database Normalisation after. We dont...

    January 21, 2016 at 3:42 pm

    #1853670

  • RE: Flag Values Based on Columns

    MMartin1 (1/21/2016)

    That would make sense since this table is a heap. The ID column is not really an identifyer in this situation. We are not recommending a practice of not...

    January 21, 2016 at 1:13 pm

    #1853629

  • RE: Flag Values Based on Columns

    MMartin1 (1/20/2016)

    Great solution Eirikur , the

    ,ROW_NUMBER() OVER

    (

    ...

    January 20, 2016 at 8:29 pm

    #1853351

  • RE: Date Function

    SumonB (1/20/2016)

    This is used because if Current Date is less than 7th of the month, it should go to previous month to set the start date

    OK, this is opposite to...

    January 20, 2016 at 3:38 pm

    #1853329

Viewing 15 posts - 1,666 through 1,680 (of 6,036 total)