Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: best way to approach this query

    Please try this.

    select distinct TransactionNumber from

    (

    select TransactionNumber, CancelDueToCorrection, count(1) over( partition by TransactionNumber) as TransCount

    , sum(case when CancelDueToCorrection = 'Y' then 1

    else 0

    end) over( partition by TransactionNumber) as...

    September 19, 2013 at 5:55 pm

    #1651726

  • RE: best way to approach this query

    Try this.

    select distinct TransactionNumber from

    (

    select TransactionNumber, CancelDueToCorrection, count(1) over( partition by TransactionNumber) as TransCount

    , sum(case when CancelDueToCorrection = 'Y' then 1

    else 0

    end) over( partition by TransactionNumber) as CancelCount

    from...

    September 19, 2013 at 5:24 pm

    #1651722

Viewing 2 posts - 1 through 2 (of 2 total)