Looks like Lutz is having to pull teeth to get the OP to read how to help himself out.

For anyone else coming along, here's the code:

declare @database nvarchar (100),@SQLString nvarchar (max),@sql nvarchar (max),@statement nvarchar (max),@sp_executesql nvarchar (max)

declare @DBs table (DBname nvarchar (100))

set @SQLString = '

SELECT name

FROM master.sys.databases...

kbnyny (9/7/2010)

This should work out good also... http://msdn.microsoft.com/en-us/library/bb964743.aspx

It's too bad we're limited to just 5 stars...

Great article Paul.

Have you got some references you can pass on about how the optimizer works?

SELECT ss.name as SchemaName,

t.name as TableName,...

Assuming that you're running a query (as stated), and not a stored procedure - just double-click on the error message. That will usually take you to either the line with...

Will this work correctly if you have two employees in the same department with the same highest salary?

rakesh 25000.00...

You can also go:

SELECT *

FROM #GermanURLs

WHERE SourceURL LIKE '%[%]%'

Hey guys - don't take this wrong. But I just love it when someone...

db_datawriter

Glad I could help. Just please respond back and let us all know how things ended up for...

That's not why I don't get on those sites. I'm one of those folks that are absolutely paranoid about protecting my personal identity... and all of those social networking sites...

When you tend to only draw hard, fast lines...

Perry Whittle (9/6/2010)

"all pirates should find their own treasure"

i do think that you presented well to the OP....