can procedure return a recordset?

How to write a procedure to return a recordset? such as P1('AA')
= select * from t1 where f1 = 'AA';
because I want to make a report and its data need to be calcuated. If the data is prepared in server and return to client one time,it can save a lot of time.
and In Delphi I can use a procedure to link a report easily. (by the way,in Sqlserver it can easily realise.)

Any Suggestings are helpful!
Thanks in advance.

YangWang.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Nov 07 1999 - 07:47:25 CST