angellll

Within the hour ;-)

CJ
LVL 22
CJ_SAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

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
All Courses

From novice to tech pro — start learning today.