i am, as you have probably noticed, a T-SQL novice. I looked up the microsoft OPENQUERY dokumentation, but its not quite clear to me how to use it in this...

OK, thanks a lot, thats it. I didn't know that a temporary table created within an exec statement, isn't accessable from my connection. So i have to use a global...

I have a problem with the execute() statement. My sql string is correct, but if i execute it with exec() then the stored procedure returns, if it is a select...

Sounds reasonable, well, i have thought of another reason, what do you think:

A sp is compiled at creation, isn't it? So, could it be that the compiler complains because it...

May be, but "Select @column from Table" is accepted...

->Flo

Thank you, exec(@query) works. But why doesn't it work with the variable in the from clause?

->Flo