Many thanks for your advice.

It worked well.

Cheers

Hi Guys

Please refer the below link.

http://www.java2s.com/Tutorial/SQLServer/0080__Table-Join/UsingAPPLYtoInvokeaTableValuedFunctionforEachRow.htm

Step 1

---------------------------------------------------------------------

CREATE FUNCTION dbo.fn_getByID(@ID int) RETURNS TABLE

AS

RETURN SELECT first_name FROM employee WHERE ID = @ID

GO

---------------------------------------------------------------------

Step 2

SELECT w.last_name FROM employee w

CROSS APPLY dbo.fn_getByID

(w.ID)...