Array / Table As return Type

Giganews Newsgroups
Subject: Array / Table As return Type
Posted by:  Sandesh (sandesh27…
Date: 16 Aug 2006

Hello All,

I have a scenario in which my stored procedure has to return few
variables with their value and also the collection. Now in SQL their is
no such as array, so the best is to return the table in place of.

I am execting the stored procedure by having sql command in place.
and created the various parameters(variables) those i need the values
of and secondly wondering how should i be creating the parameter as a
table returntype.

Any help on this would be a million worth useful.

I can excerpt the code if required.

Sandesh Kadam