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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-11 : 08:32:23
|
| Raj writes "I am having a hard time try to find a work around this issue. This is a known Microsoft bug. I can't alter an existing view when I added a left join that contains a UDF. for example,LEFT JOIN Tablename ON TableName.ID = dbo.fnUDFName(Parameter).The Function return an ID . The error is Could not find database ID 102. Database may not be activated yet or may be in transition." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-11 : 08:34:24
|
| How about...not using the UDF for the join? Unless the UDF calculates a mortgage payment or something similar, it's very likely you can modify or create some tables to support the data needed to accomplish the join. You may not even have to do that much. Posting the code to the UDF, and the structure of the tables it uses, would help. |
 |
|
|
|
|
|
Left Join , View and Function