Thank you all for having a go at this.

I don't see any  realistic way to get around this in a timely manner, and can't really justify spending anymore...

Not easily with a real-world example, I'm afraid.

I know.:crying: BIGINT can handle the 56 case. But we have 237 groups in on province.

Let me rephrase: my users have created various groupings of cities...

Ah sorry. Yes, SQL 2008

I'm not really sure that SQL server is going to be the right answer for this. I assume that you can use an...

Yep.

Mine too. Here's the final version. I didn't mention before, we also have phrases and synonyms of phrases.
Managed to get rid of the cross apply, which makes me considerably...

Sorry, was -- and am  -- out to lunch :Whistling:

Precisely!

But thinking on it over food, I may have been making this harder than it need...

See also: https://www.reddit.com/r/PowerShell/comments/4eylez/converting_sql_data_types_to_system_data_types/
Which nicely wraps things up!

Solution: need to get the column info from the DataSet.Tables object.

$Data = $objDB.ExecuteWithResults($Query)
# This gets the columns in order
$Data.tables[0].columns | sort -Property ordinal | select...

In short,
- the guy who modeled this insisted on doing it (t)his way. We let him. He doesn't work here anymore.
- I'm trying to get the...

Well that seems weird...

However, I experimented with a move and a copy and, in both cases, the permissions were as expected, and identical.

I had the...

Thanks Chris, that did it when I changed the ORDER BY to use the date in the ROW_NUMBER()

Much appreciated!

All:

I goofed on the expected results in the OP: here's how they should appear.
The PK (nrev_Id)  can be out of calendar sequence (because users), so that...

It takes a while, longer depending on the number of servers you have. About 10 seconds for my ~20 instances.