Ok great. Thanks Steve, I appreciate your feedback.

Hello all,

I know this is an old thread but any feedback would be appreciated.

I am busy implementing tSQLt in my SSDT project.

I am...

That is what I was looking for!

Need to work on my XQuery knowledge.

thanks for the help 😉

thanks Chris, will check this out

very handy! thanks for the help

By the way, how do you format your results like that? I looked through all the shortcuts and could not figure it out!

Is that an image or just SQL tags?

Hello,

I appreciate the thoughts and observations.

This is a theoretical allocations table, so it would only have the Payments required to fulfil the Deduction.

Usually, we would have a Receipt and an...

Thanks Chris, this is exactly what I was looking for!

The db is in SQL08R2, so LAG is not going to work, but I am sure that I can get around...

Hi Luis,

Thanks for the advice, I had not thought about the set based loop/cursor approach.

Interesting article, I will try and relook at the original problem and see if I can...

looks like the QotD is wrong!

That looks much better than my attempt.

Agreed, this solution took a lot of time to get to.

Thanks for the help

Hey Steve,

Happy Friday!

Yes the order is irrelevant as the BenID can go through various combinations with the BenIDNew (these are Beneficiaries that are transacting).

Your solution is much more efficient than...

In case you were wondering, this was the final solution.

The other scripts partially worked, if you tested with ID 198, it did not return the full list of relations, looking...