• sanajmshaji (11/9/2011)


    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) AS r

    ORDER BY w.ID;

    ======================================

    GO

    That won't work in sql2000. There is no CROSS APPLY yet. 😀

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/