This works for me.

create FUNCTION [dbo].[fn_MyFunction]

(@ID INT)

RETURNS @return_table TABLE

(Col1 int NULL,

Col2 int NULL)

AS begin

--- processing goes here...

INSERT @return_table

SELECT 1, 2 union all

select 55, 73

RETURN

end

go

declare @var1 int, @var2 int;

select @var1 = col1, @var2 = col2

from dbo.fn_MyFunction(1)

select @var1, @var2

However the reason I suggested using a temp table is because you want to capture all the rows not just one. If you don't need multiple rows you should consider a complete rethinking of what you are doing. For that type of situation it would be better to use a stored proc with multiple output parameters instead of using a multi statement table valued function.