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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Inline UDF

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-09 : 09:17:04
David writes "Can I pass the table name as a parameter to an inline UDF? I thought I could use a CASE statement but it gives me syntax errors. My goal is to call the UDF from a stored proc to return a value. The problem is the value may come from any of 5 tables based off of parameters passed to the stored proc.

Thank-you."

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-08-09 : 10:46:58
What gives the error ?
Case statement ? Parameter passing ? Exec command (executing dynamic SQL) ?

Srinika
Go to Top of Page
   

- Advertisement -