Hi,
> I actually mean results sets, multiple rows returned.
> I have had problems with the exact syntax against
> ms sql server all the time, and was worried it is not possible to do it.
> I was able to find more references to Oracle by googling etc but thay
> syntax didn't seem to work for me as it is. But I wll give it another go
now.
I've asked a colleague, his suggestion:
select * from my_function (1, 3)
The function my_function has to be declared as:
CREATE FUNCTION my_function (
@in_type int,
@in_id decimal(15,0))
RETURNS @my_table TABLE (a_id decimal(15,0)
, b_id decimal(15,0)
, c decimal(17,1)
, d decimal(28,2) )
AS
BEGIN
...
END
HTH,
Martin
