I know this is a little late, but thought I would post it in case someone else came across this post looking for answers...

Matthew Mark (3/10/2008)

---

I cannot update system catalogs.

Okay,...

In Enterprise Manager, you can generate a single script for ALL tables in the database (all in a single file).

Highlight the DB name, rt click, select 'generate SQL script', click...

I'm not sure if I follow you, but in Query Analyzer you can also right click the table name to generate the 'create' script for the table.

Is this what you...

Yep, what Matt said. I posted a few seconds after he did, so I didn't see his post.

This is what the link I sent earlier was explaining as well.

This...

Ok, seems OPENQUERY has an issue with concatentation.

Here is a solution...see this link...it explains your problem exactly.

http://wisetown.com/

You have to actually build the entire SQL, including OPENQUERY, the insert, etc in...

OK, I just read on BOL...

'OPENQUERY does not accept variables for its arguments.' (sorry, I missed that earlier)

So, now that you know that the SQL is good, put your string...

Don't hardcode it, take the output of 'SELECT @sql' and run it on the linked server to check to see if the SQL syntax is correct (because that is the...

Have you tried to run the SQL (select blah, blah, blah, etc) directly on the linked server?

Try this so you can verify the SQL....

declare @sql varchar(500)

set @sql = 'SELECT [Test 1] AS Test1, [Test 2] AS Test2, [Sum of ' + @month + '] AS MonthlyAmount...

If you needed the last (max) PeriodEndDate for each consultant, you can add it in like below.

This was suggested in your error...column must be in a 'group by' or an...

Right, because you are using SUM in your select. You must remove the PeriodEndDate from the SELECT as well.

Why do you want the PeriodEndDate if you are summing all...

Because you have PeriodEndDate in the 'group by', it is using the date as part of the grouping, which is why multiple rows for same consultant (note that dates are...

Don't worry about it ... we all have our moments. That's why it helps having so many sets of eyes on here to look...

There is no range specified in the 5th query, so you should be getting all values.

I got the...