>Hi everybody,
>
>I want to create an SP, which would receive
>CartID, FieldList1, FildList2, FieldList3 as input parameters and have 3 output parameters Rec1, Rec2, Rec3. Return value - error code.
>
>Inside this procedure I want to call either function or procedure, which would return resultset as a table.
>
>Something like
>function ReturnInfoByStateCategory
>...
>return info as a cursor.
>
>Should I use UDF or SP with Cursor Output? Which way is preferable?

Only UDF can return table.