CJ_S
asked on
angellll
Within the hour ;-)
CJ
CJ
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why?
Ask bill.gates@microsoft.com
SET ROWCOUNT @x
works to limit the output of the entire select, but wouldn't help in this case, as it won't affect the subquery...
CHeers
Ask bill.gates@microsoft.com
SET ROWCOUNT @x
works to limit the output of the entire select, but wouldn't help in this case, as it won't affect the subquery...
CHeers
ASKER
I knew about the rowcount but I wanted it to make the query more dynamic.
Anyway. Thanks again!
CJ
Anyway. Thanks again!
CJ
ASKER
declare @x int
set @x = 3
select top @x * from ...
does not work? been wondering this for a couple of weeks now. :-/
CJ