>Can you use dynamic SQL in your query? This way you can parameterize Top.
I considered it, but am a little shy to use dynamic SQP because of the traffic that this SPROC will get (on the order of hundreds of hits per second). Wouldn't dynamic SQL require that the statement be compiled on every hit? That would be unacceptable...
Erik Moore
Clientelligence