Forum Replies Created

Viewing 15 posts - 14,026 through 14,040 (of 59,063 total)

  • RE: Code for 'week to date' DATETIME() mine is displaying previous weeks

    chef423 - Tuesday, October 17, 2017 4:45 PM

    Lynn Pettis - Tuesday, October 17, 2017 4:36 PM

    October 17, 2017 at 5:06 pm

    #1964123

  • RE: Using Case with 2 different variables in one query

    montserrat.deza - Tuesday, October 17, 2017 3:46 PM

    Hello Experts,
    I am trying to use 2 cases in the same query and is not...

    October 17, 2017 at 4:19 pm

    #1964112

  • RE: Partition/Over Window Woes

    alex.sqldba - Tuesday, October 17, 2017 8:38 AM

    Well, I never knew you could put a case statement within a sum() ... AMAZING!!!

    Thanks...

    October 17, 2017 at 4:14 pm

    #1964110

  • RE: SQL CPU maxing out - need some guidance

    FritsD - Tuesday, October 17, 2017 3:16 AM

    Hi Jeff, thanls for the reply. No we didn't use EF and don't have MARS...

    October 17, 2017 at 6:01 am

    #1963994

  • RE: Using Date in Where Condition

    ChrisM@Work - Tuesday, October 17, 2017 5:50 AM

    Did you notice the timing for the fourth case, Jeff? It's just as...

    October 17, 2017 at 5:55 am

    #1963992

  • RE: Very challenging TSQL Query

    Naveen J V - Monday, October 16, 2017 8:58 AM

    Hi Experts,

    I have a table (test) with the following data :

    October 17, 2017 at 5:51 am

    #1963991

  • RE: Using Date in Where Condition

    ChrisM@Work - Tuesday, October 17, 2017 5:05 AM

    Jeff Moden - Saturday, October 7, 2017 9:10 PM

    October 17, 2017 at 5:44 am

    #1963989

  • RE: Very challenging TSQL Query

    hapsa10 - Monday, October 16, 2017 11:10 AM

    Podrías intentar hacer algo como esto.

    ;With CTE_Source As (
        Select Fl, Col
        , Val = Case
                    When...

    October 16, 2017 at 5:29 pm

    #1963947

  • RE: Very challenging TSQL Query

    Alan.B - Monday, October 16, 2017 3:01 PM

    hapsa10 - Monday, October 16, 2017 11:10 AM

    October 16, 2017 at 5:26 pm

    #1963945

  • RE: Very challenging TSQL Query

    hapsa10 - Monday, October 16, 2017 11:10 AM

    Podrías intentar hacer algo como esto.

    ;With CTE_Source As (
        Select Fl, Col
        , Val = Case
                    When...

    October 16, 2017 at 5:20 pm

    #1963944

  • RE: Today's Random Word!

    Ray K - Monday, October 16, 2017 1:00 PM

    ZZartin - Monday, October 16, 2017 12:24 PM

    October 16, 2017 at 5:14 pm

    #1963943

  • RE: could some one help me with the query below

    Lynn Pettis - Monday, October 16, 2017 9:49 AM

    So, your policy is that all databases are to use the SIMPLE recovery model? ...

    October 16, 2017 at 11:53 am

    #1963909

  • RE: Timing is Everything

    It's real simple, in most cases.  I just ask them how to get the current date and time in SQL Server. 😉

    October 16, 2017 at 9:49 am

    #1963866

  • RE: could some one help me with the query below

    David Burrows - Monday, October 16, 2017 8:27 AM

    I have never used it but according to the spec referenced you are using...

    October 16, 2017 at 8:39 am

    #1963848

  • RE: The Cloud is Better In At Least One Way

    Steve Jones - SSC Editor - Monday, October 16, 2017 7:44 AM

    Any particular person can out optimize the cloud, especially for value...

    October 16, 2017 at 7:59 am

    #1963831

    • Viewing 15 posts - 14,026 through 14,040 (of 59,063 total)