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...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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,...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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,...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    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

    (

    ...

    _____________
    Code for TallyGenerator

    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...

    _____________
    Code for TallyGenerator

    January 20, 2016 at 3:38 pm

    #1853329

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