@jacob, thanks as well! I will take a look at this approach as well - much appreciate everyone's help!

This was exactly the case! I can't believe I completely overlooked that...wow I feel like an idiot :hehe:

The developers used UniqueID as the PK because in the table they...

I'm not saying that at all. Check out the original execution plan, looks like it's doing some cartesian product in the portion of code I originally posted.

In the example...

Whoops, attachments added.

Yes it runs super quick using "test" data, but the original procedure can takes 20 minutes depending on how much data gets loaded into that temp table. ...

You'll immediately see the problem query in the original execution plan doing the 1.14 billion rows between the Table Spool and the Nested Loop

I was hoping there'd be a "Oh you just need to do it this way" by looking at the code...but knew I'd get dinged on the lack of preparation on...

I don't fully understand how this works to detect changes at the table level. BOL states that 'ALL' is the default value yet using 'ALL' doesn't work when you...

Winner Winner Chicken Dinner 🙂

Thanks a million man! Working like a champ!

Not sure I follow you (sorry) or I am not communicating my intent properly.

This is a server that has the default MSSQL service and SSRS service already installed; and works...

To clarify, I am trying to use multiple SSRS instances on a single database instance

I'm in need to accomplish the same thing on a SQL 2008 install. I installed the second reporting server instance...successful.

But how to set it up?

I don't see a 2nd...

Thanks a lot for this, had to create an index on the larger table been hit but it does work well!

I had to completely disable replication altogether and start over.

In retrospect, I believe if I had run the distribution cleanup agents prior to attempting to re-add the publications, it might...

Not sure if this helps or not but basically an rss file consists of a few basic "chunks":

1. Declarations

2. Parameters Collection

Full Rss File Example:

'Report Config Parameters

Dim format as string =...

Short and sweet!:-)