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?