Forum Replies Created

Viewing 7 posts - 16 through 22 (of 22 total)

  • RE: Sum when between

    bmg002 - Thursday, July 13, 2017 3:57 PM

    Looking at your data set though, are you sure it should be 3?
    I am just...

    July 13, 2017 at 5:39 pm

    #1950862

  • RE: Sum when between

    TheSQLGuru - Wednesday, July 12, 2017 8:13 PM

    Look up Itzik Ben-Gan Gaps and Islands TSQL to find a number of solutions to...

    July 12, 2017 at 10:07 pm

    #1950671

  • RE: Sum when between

    Thanks, updated.

    July 12, 2017 at 8:01 pm

    #1950664

  • RE: Case statement - Count When

    TheSQLGuru - Wednesday, July 5, 2017 7:25 AM

    danijel.bozic87 - Tuesday, July 4, 2017 10:02 PM

    July 5, 2017 at 5:01 pm

    #1949590

  • RE: Case statement - Count When

    John Mitchell-245523 - Wednesday, July 5, 2017 5:50 AM

    case
        when (sn_type='De-Activated' and sn_status='COMP')
            or (sn_type='Re-Activattion' and sn_status='N-CO')
       ...

    July 5, 2017 at 6:01 am

    #1949437

  • RE: MAX MIN OR SUB-QUERY

    I have color coordinated my logic. Hope this makes a little more sense.

    June 30, 2017 at 10:10 am

    #1948968

  • RE: MAX MIN OR SUB-QUERY

    Hi Chris 
    Sorry, i could have explained better
    I have attached a file below.
    With the table below I am able to see how long the ID took to get to each stage...

    June 30, 2017 at 4:19 am

    #1948895

Viewing 7 posts - 16 through 22 (of 22 total)