Chris Harshman (11/1/2016)

---

if this query is only ever meant to return 1 row, then maybe instead of calculating a generic flag 'x' in the CASE statement, calculate a preference:

SELECT TOP...

thank you ZZartin!

The Value "ThisRec" can be anything and there is a possibility of having multiple records based on the other criteria.

thanks!

I think we have it, but for completeness, can you please confirm that if there is only an Online order, i.e. that the OrdID does not also have a match...

Thank you all for the replies!

@jacob Wilkins - You are correct, if there are two or more MtchId's with "Phone", "Online" and other OrdLoc's I want to display...

Thank you all! for your valuable inputs.

Thank you!

This part

"SUM OVER" & "ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW"

Thanks!

yb751 (1/21/2016)

---

At least you provided the sample data which is more than some. 😉

Good to know...

I'm trying to, but it would help If you could provide a brief explanation.

Thanks much!

Thank you yb751!

The real data has dates, but I wanted to simplify it.

Thank you!

Thank you J Livingston SQL! It worked.

Thanks you Luis C and Micky! Both the solutions worked like charm.

Hi, Thanks for the reply.

Sorry, forgot to mention, there is a seq number.

CREATE TABLE #xy123

(

tktamt MONEY,

...

Thanks for the reply Abu Dina and Ed Wagner!

We have SQL sever 2000 database, I am not sure If I can use this in SQL server 2000?

Thanks!

Okay Lynn Pettis, Actually I want to code for the 'O' part of the case statement and populate a flag, that is the reason, I was trying to re-write it...