Stored procedure question

[LasVegasGuy]

How do you write a stored procedure/function that returns recordsets? Thanks Man Learns from History that he never learns from History

[Bill Dean]

in sql? Just have the last statement of the sproc be a select that returns the "table" of data you want.

[Mazdak]

Simply , when you write a query there it return recordsets,for example: SELECT * FROM table1 when you put it in a SP it will return all recorsets from that table. Mazy "Improvisation is the touchstone of wit." - Molière

[Husein]

CREATE PROCEDURE MyProcedure AS SELECT * FROM SomeTable I hope this helps. Functions are slightly different. There are three types of functions, those that return scalar value, inline table-valued functions and multi-statement table-valued function. The one that you might want is inline table-valued function CREATE FUNCTION MyFunc RETURNS TABLE AS RETURN (SELECT * FROM SomeTable WHERE SomeColumn = SomeCriteria)