Prev: Using table valued parameters to delete and update a table
Next: SQL Server 2005 Stored Procedure Performance
From: Plamen Ratchev on 22 Mar 2010 21:43
Since this is a table valued function you can use it with CROSS APPLY:

....
SELECT <columns>
FROM MyCTE AS C
CROSS APPLY dbo.tfs_GetGroupAncesters_Function(var1) AS F;

--
Plamen Ratchev
http://www.SQLStudio.com
First  |  Prev  | 
Pages: 1 2
Prev: Using table valued parameters to delete and update a table
Next: SQL Server 2005 Stored Procedure Performance