Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ImadElayyan
Starting Member
1 Post |
 Posted - 2008-04-29 : 08:15:22
|
| 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. SELECT *FROM Customers 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,Imad Elayyan |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-29 : 08:29:14
|
Urgently, no you can't.But there is a workaround. If you can return the attribute(s) from the function as a CSV list or similar, you can process the list and "convert" them to columns in the outer query.But as alwasys, we need to se your query before making any more assumptions.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
CROSS APPLY Equivalent