Viewing 9 posts - 1 through 9 (of 9 total)
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...
December 23, 2002 at 9:47 pm
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...
December 22, 2002 at 1:47 am
I Would like to thank you all guys for your help.
Regards.
December 18, 2002 at 5:30 am
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.
...
December 18, 2002 at 4:32 am
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...
December 18, 2002 at 4:14 am
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...
December 18, 2002 at 4:13 am
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...
December 18, 2002 at 3:12 am
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...
December 17, 2002 at 9:56 pm
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...
December 17, 2002 at 9:56 pm
Viewing 9 posts - 1 through 9 (of 9 total)