I have a question, is there any equivalent for the CROSS APPLY operator in SQL server 2000?
I have the following code in SQL Server 2005 and it works fine, but I need an equivalent code in SQL server 2000.
FROMCustomers Cust CROSS APPLY dbo.GetAccountAttributes(Cust.AccountNo) Att
what I need is to join a function and passing it a dynamic parameter.
I need it urgently
Thanks in advance,
The GetAccountAttributes function get the information from linked server and I can't remove the function and write the queries in the stored procedure because I need the access to the linked server is centralized in just one location
Function GetAccountAttributes(@AccountNo varchar(50))
WHERE X = @AccountNo
Nitin Khurana wrote: Remove the function and use a join, u may also make use of a CTE and then join to base query to keep it simple.
CTE's are not available in SQL 2000. If the code to the function could be posted, a viable derived join could be created that allows this to function in 2000.