@JeffModen - your solution and my solution are very close to the same.  If we pass in 2022 as the starting year - both version return an empty...

What is the criteria for your Match/NoMatch condition?

For example... are you looking for matches by whole line in the files?  If not, how do you need to differentiate which parts...

Ah, be careful, now... There actually IS a problem with making a view for every table... if you make a change to the table, you need to remember to "refresh"...

In the absence of any code, the one thing that might have helped me to help you was the Predicate listing.  So much for that, eh? 😉

It might be the default but doesn't apply in this situation.

0 = varchar(max), nvarchar(max), varbinary(max), xml and large UDT values are stored directly in the data row, up to a limit of 8000 bytes...

@JeffModen - your solution and my solution are very close to the same.  If we pass in 2022 as the starting year - both version return an empty set. ...

WITH
    E1(N) AS (SELECT 1 FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1))E0(N))

I don't understand this syntax (please note that I'm not a DBA - my day job...

@jeff,

Thanks for the feedback but my question was how do I autoupdate the decommisioned column using a query or some script that says the server is decommisioned ? My...

Thank you so much everyone for your interesting, thoughtful and useful answers and contributions.  I didn't 'leave the building' but I'm in the UK and after work stops, I...

I have an actual TALLY table in my database for Numbers ... is that bad? should I be using a Function?

Obviously there is a limit on the number of...

Apparently, the Op left the building.

With the idea of doing some bullet-proofing to return no rows for "illegal" years instead of producing an error (induced "silent failure) to expand upon...

After the 30 days, move them to some type of historical table.  Personally I would never permanently delete such data.  Compress it to the max and it will take...

Totally understood...

I'm thinking that the OP has left the building.

We have an end to end server inventory collection process - all automated from server collection to data collection from those servers.Servers do get decommisioned...