Okay, so maybe I am a little dense.

I guess what I missed from Scott's post was that all of the "THEN"s will be evaluated even if it does not pass...

I tried his suggested format in your code as well.

No good.

Same error on the final cross apply.

When I comment out the last cross apply, I do get results for t, x, and y.

ChrisM@Work (2/6/2013)

---

CASE WHEN ISNULL(T.Target, 'N/A') IN ('','N/A', 'TBD')

If column T.Target has values of 'TBD', what other character data does it contain which cannot be implicitly converted to decimal(15,4) - and...

ChrisM@Work (2/6/2013)

---

T.Target isn't one of the numeric datatypes. You're only trapping one string value from being bassed in to the function, are you sure there are not more? Have you...

Thanks for your response.

I made the change you suggested and still get the conversion error.

Brandie Tarvin (1/25/2012)

---

I would be tempted to look at the code that enters the transactions and see if there is anything there that can be cribbed into your solution. But...

Alright. As Jason suspected, I just needed to spend some time putting together all the required data for you guys to work your magic

and the solution would appear.

I have a...

Okay, I'm not sure, but I think you guys didn't like that query :hehe:

I was a little rushed last night and just hoped one of you would see what I...

Both TranType 1 and TranType 2 are valid transactions on there own or are used to reverse the opposite transaction.

The way the system works:

Using the sample data provided, assume only...

Thanks Mark.

I will give it a go and let you know.

Can you provide some details about how this works?

I would like to understand the concept, so I can do...

Thanks for spending time on this.

Do I win a prize? 😀

Is there something else I need to add?

Or am I just stuck with RBAR?

TranSeq 1 & 2 would match. 3 would not match.

I get what you mean about the transaction period thing but "inside out". That is pretty ambiguous. Do you look first for an earlier one and then a later one?...