[GENERAL] SQL Server stored procedures?

[Todd P Marek]

Hello-

I have been trying for a while to write a function that would return multiple rows and columns in a similar fashion as SQL server stored procedures.

I can get my functions to return multiple rows and columns but only from a single table. I worked around this by creating a view that ties all my tables together like so (basic example)-><x-tad-bigger>

CREATE FUNCTION usp_grab_classes() RETURNS SETOF classes
AS 'SELECT classes.* FROM classes'
LANGUAGE 'sql';

</x-tad-bigger>I am curious if there is a way to select and return multiple columns from multiple tables without having to first create a view.

Any help would greatly appreciated.

Todd Marek<x-tad-bigger>

</x-tad-bigger>"If you think you understand something it's habit."
--Gary Kraftsow--