Storing return type from a function

[tonnet]

Hi
I have one function returning TABLE and I want to save the value returned by this function into a stored procedure to reuse later.

Function:
CREATE or replace FUNCTION list_to_tbl (@list nvarchar(MAX))
RETURNS @tbl TABLE (ename varchar2 NOT NULL) AS
BEGIN
....

Stored Procedure:
REATE PROCEDURE testme1 @ids varchar(50) AS
declare @mytable TABLE
set @mytable= list_to_tbl((@ids)
------------
-----------

But I am not able to set the value as getting error at statement :
set @mytable= list_to_tbl((@ids)
The MS SQL server is expecting a built-in function not an user defined one.
Please help...

[Infide]

Hi
I have one function returning TABLE and I want to save the value returned by this function into a stored procedure to reuse later.

Function:
CREATE or replace FUNCTION list_to_tbl (@list nvarchar(MAX))
RETURNS @tbl TABLE (ename varchar2 NOT NULL) AS
BEGIN
....

Stored Procedure:
REATE PROCEDURE testme1 @ids varchar(50) AS
declare @mytable TABLE
set @mytable= list_to_tbl((@ids)
------------
-----------

But I am not able to set the value as getting error at statement :
set @mytable= list_to_tbl((@ids)
The MS SQL server is expecting a built-in function not an user defined one.
Please help...

Try this:
DECLARE @mytable Table (field1 varchar(2))

INSERT INTO @mytable
SELECT ename
FROM list_to_tbl(@ids)