Done .. .thanks 🙂

The use of a physical Tally Table DOES...

Have you got an index on SearchParts, CompanyId (with the Keys in THAT order provided that CompanyID has many rows and SearchParts is reasonably unique)? If...

I missed the point about starting with a view from day one.  If the only reason for using the view is to allow for 'future' refactoring - then I...

Thanks for your help Steve

Using them on once instance works, but you still have a name resolution issue. The db names are different, so the connection string is different....

sys.objects gained a [modifed_date] column at some point, but I can't remember which SQL Server version

SELECT *
FROM...

Dunno if this is any good as a suggestion, but if you DROP the database before the restore or it doesn't exist, then if the database exists after the...

Impotent? ... I'll get my coat ...

In my rollout scripts (mechanically generated) I have a #TempTable for anything that...

After the fact:

Restore database from backup (to a temporary database name Natch!), before the event, and compare the two

if you have transaction log backups then restore to POINT IN TIME...

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 values...

In that...

Further suggestion, hopefully the learned people here won't be horrified?

SET STATISTICS IO ON; SET STATISTICS TIME ON

... statements to be tested here ...

GO
SET STATISTICS IO OFF; SET...

We replaced Temp Tables with Table Variables when they first came out because we assumed they must be wonderful 🙂 ......

Indeed ... but maybe it would be easier / safer to leave the existing "automated inventory collection process" unchanged and add a 1:1 table alongside for the...

It's often a good idea to have all code use a view to the table rather than directly modify the actual physical table, since it can make table changes...