Also the configuration of tempdb database may have impact on performance of temp tables. If you have 1 million records, you should create indexes on these temp tables on fields...

seems that you use alias 'c' when you generate column name, but do not use this alias for the table name in the query.

...SELECT @Line = @Line + 'c.'+...

Yoou can update only one table at a time. I imagine that kind of functionality that you'd like would create quite interesting effects regarding transactions.

Wrap two updates into one transaction...

You can't use local system account to get to another machine using integrated authentication. Try to run this daemon under a domain account that will be granted access to database...

Why do you have two MPG fields in the query? Seems that one is taken from table (and is NULL) and the second is calculated and aliased to the same...

Besides, maybe it would be better to use linked server to excel?

Piotr

it's same query then, just different role_id in it.

Piotr

I agree, using COM in server environment is tricky. The least can happen when something goes wrong is stealing memory - after some time - day, week or month, serwer...

This code presented by Adam should return rows in normal way, provided there are data for given combination of parameters.

How many columns do you have? If a few only, I...

Heh sorry, I was unclear 🙂

I also asked about clipboard as this kind of errors often occurs when you copy and paste code 🙂

Piotr.

select DATEPART(year, GETDATE())

copy and paste? 🙂

Piotr

Don't know if it is applicable in your case, but I would ask about any linked servers that database might require. 64bit oledb drivers can be a pain..

how did you restore the database? maybe you have used NORECOVERY or STANDBY modifier?

Piotr

[font="Courier New"]alter database yourdb collate new_collation[/font] will change database collation, which will be used for new objects created in this database. Yet if you want to change collation of existing...

Won't

SELECT * FROM openquery(My_Excel, 'SELECT * FROM A5:B20')

work once you have the server configured? Openrowset is an ad hoc linked server after all.

Piotr