Thanks Tim. It is not your fault, it is the fault of Microsoft, as it is logical to assume that you can use a table variables as any other scalar...

Thanks Tim for your post...

I've tried what you've suggested, but with no success. output parameters can be anything but table variables. Here is my code:

DECLARE @flights_table TABLE (RecordID int...

I Would like to thank you all guys for your help.

Regards.

Thanks antares686....

But how to retrieve the results of a subquery without temp tables? in other words I want to store the results of a subquery into table variable..

is that possible?

Regards.

...

Thanks again,

That would return us to the original problem where I have no problem with SET ROWCOUNT and temp tables but only with table variables... It seems like there is...

Thanks again,

That would return us to the original problem where I have no problem with SET ROWCOUNT and temp tables but only with table variables... It seems like there is...

Thanks again,

But as I have stated in my previous post I cannot use a subquery because I cannot retrieve the results of the subquery into a table variable since it...

Thank you all guys.

Paulhumphris, the TOP keyword solves the problem and the results are excellent. However, the TOP keyword requires the use of an explicit number, not a variable. And...

Thank you all guys.

Paulhumphris, the TOP keyword solves the problem and the results are excellent. However, the TOP keyword requires the use of an explicit number, not a variable. And...