angellll

Within the hour ;-)

CJ
LVL 22
CJ_SAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
Glad I could help
0
 
CJ_SAuthor Commented:
By the way. Do you know why

declare @x int
set @x = 3
select top @x * from ...

does not work? been wondering this for a couple of weeks now. :-/

CJ
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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

0
 
CJ_SAuthor Commented:
I knew about the rowcount but I wanted it to make the query more dynamic.

Anyway. Thanks again!

CJ
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.