Home Forums SQL Server 7,2000 T-SQL How to join a table-valued Function RE: How to join a table-valued Function

  • April 2, 2008 at 10:46 am

    #797399

    J (4/2/2008)

    Sergiy (10/17/2007)

    Mike,

    unfortunately there is no such thing as "CROSS APPLY" in MS SQL 2000.

    In MS SQL Server 2000, you can get a cartesian product simply like this

    J -

    Note that he was talking about cross APPLY, not cross JOIN. CROSS APPLY is used to call table-valued functions based on column values. It is essentially a fancy implicit version of correlated sub-queries, not the Cartesian Product as done with CROSS JOIN.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?