Is this what you are trying to accomplish?  (Please note I commented out the actual execution of the code):

declare @cols table (id int identity(1,1),colname varchar(255))

I did the following and all run fine:

create view dbo.view1 as
select * from sys.objects;
go
create view dbo.view2 as
select * from sys.objects;

Each of these run?

SELECT 1 WHERE
EXISTS (SELECT NULL FROM View1 WHERE field1 =

Just love those "Solve my architecture" questions we some times see.  Let's see, do your job for you for free or walk away?  Walk away!

Just looking but I'm not sure what you are expecting based on the sample data and DDL you provided.

It has been a while but when I did experience this type of problem it usually turned out to be misconfigured Distributed Transaction Manager on one or both servers.  This...

I think it really depends on what you read.  I have also seen posts where 10e1 = 10.  Same search page that the links above point to.

Can I simply say that I hate importing data from an Excel spreadsheet?  I much prefer a delimited text file; comma, pipe, tab.  The type of delimiter depends on the...

Your question is quite broad, and not something that can be answered in a short concise forum post. If you could ask more concise questions we can perhaps help you in...

Not sure what you mean by report size.  The data for each report is stored in either the main report table or one of numerous sub-tables for a specific report...

To answer the questions, in no particular order.
TableOfContentsKey to ReportKey is one to one.  Yes, doesn't quite make sense why there is a TableOfContentsKey but there is.  This is...

I could use some constructive feedback here.  Thanks.