If you have multiple users how do you keep the result set seperate?  Does it use sessions?

Okay, is there way to create a stored proc that you can then call in a sql select statement.

For example:

proc name: sp_FooBar

SELECT * FROM sp_FooBar;

When I try to do this...

Wow...so...Do you have a recomendation on how to do pagination in a stored proc.  I have done it using PHP with the select statements in the PHP script, but I...

That was exactly what I am doing...Ok..So I have a new problem..

PAGINATION....

I want to bring in a dynamic limit actually two!

@MYLIMIT  int,  /*Input parameter

SELECT * FROM(SELECT TOP  @MYLIMIT PARAMETER FROM(SELECT @LIMITVALUE...

Thanks....nice....worked great...I wasn't brain farting...I just didn't know.

Did I say thanks yet....

anyways...THANKS