Steve, please excuse me for being obtuse, but what did you mean by, "...  one thing I'd recommend is make a REPO to keep your code review checklists"? I'm...

If you are simply trying...

This function might help you: https://www.sqlservercentral.com/scripts/patexclude8k

What sort of input? A file?

I'm working on this very topic, so this article was timely.

There is a statement in the article: "The template parameters can be overridden as required" which may not be as...

Your DISTINCT, as written, applies to the entire combination of (P0ISBN, p0CHN, P0WEDT, P0ADAT), not only to the date.

If you provide your data in a consumable format, someone here will...

Difficult to write this query without some sample DDL and data.

But...

You want the top 10 for each year, or just the top 10 for eternity?

(I ask, because your sample code references YEAR(OrderDate) all over the place, though you do not...

All of the dis values in your sample data are different, so therefore grc will always be zero. Your sample results therefore do not match your written logic. Please clarify.

You've declared a CTE, but then you do nothing with it.

Add SELECT * FROM MissingAttendance, for example, at the end and it should be fine.

Thanks for your feedback Phil,

The reason for the layout of my sample data was just for simplicity.  I inserted my sample data into a physical table and then just...

What tools are you using to deploy and to generate the delta?

For the benefit of others, here is a consumable (and simplified) version of your set-up code. Please note in future how dates should be in 'YYYYMMDD' format (no need to...

Does this help? It relies on Jeff Moden's infamous splitter which, given the number of points you have, I imagine you've heard of.

DROP TABLE IF EXISTS #PipeStringTemp;

CREATE...

This does not appear to be a SQL Server post.

Also, is it a blog post, or do you have a question to ask?

If you expect a coded answer, please provide...

• This reply was modified 1 year, 11 months ago by Phil Parkin.