You primarily need information in the system tables, which you can generally get from INFORMATION_SCHEMA.

Going to need a LOT more details.   Give us a test scenario with mocked up data, including table create scripts and the mocked up data as INSERTs, and then what...

How about we batch these and properly identify it all, as follows:
CREATE TABLE #MyTable (
    RowID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
    BatchID INT NOT NULL,
    WillField VARCHAR(10),...

Forget about getting the benefit of indexes because of the following snippet:
and MAT like '%Light%'"

Every row is going to have to be read, and with a large...

Heading out for the day.  Will have to get to this tomorrow if the query finally does get posted.

How do you assassinate a DBA ?

I would never rely on knowing that an SSRS report has been printed for this kind of functionality.  The only good way is to have a table that has a...