Forum Replies Created

Viewing 15 posts - 856 through 870 (of 1,413 total)

  • Reply To: How to check if NextDay is Holiday (exclude Saturday and Sunday)?

    Just a note about the table design.  For this purpose all of the rows which are not a holiday are irrelevant.  Meaning if there were a table of just holidays...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 26, 2020 at 2:56 am

    #3791053

  • Reply To: Ignore the entire record if a matching record is found 

    select distinct a.KeyId
    from applications a
    where not exists (select 1
                      from...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 26, 2020 at 2:38 am

    #3791049

  • Reply To: How to check if NextDay is Holiday (exclude Saturday and Sunday)?

    Here are two ways depending on whether GETDATE() returns the date you're interested in.  If it does you could use something like this

    /* use GETDATE() to determine...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 26, 2020 at 2:13 am

    #3791047

  • Reply To: Are the posted questions getting worse?

    Eirikur Eiriksson wrote:

    My "favourite" response ever for that question is "do you mean now?"

    We're in now now

    https://www.youtube.com/watch?v=nRGCZh5A8T4

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 25, 2020 at 2:30 pm

    #3790959

  • Reply To: Are the posted questions getting worse?

    Jeff Moden wrote:

    "How do you get the current date and time using T-SQL question that 20 out of 22 candidates couldn't answer before I stopped counting.  It's NOT a trick question,...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 25, 2020 at 2:12 pm

    #3790951

  • Reply To: Where do I start from ?

    There's a documented process for submitting performance issues.  In the footer of Jeff Moden's forum posts there's a link.

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 24, 2020 at 10:15 pm

    #3790833

    • Viewing 15 posts - 856 through 870 (of 1,413 total)