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 |
|
freq
Starting Member
17 Posts |
 Posted - 2012-02-09 : 14:26:16
|
| I created a function that will parse the domain out of an email address.I'dl like to apply that function within a stored procedure to a select statement.The function name is Trim_Mobile_Phone_Domain.Below is what I have so far (but can't get to work). SELECT Att_EMA_ID, dbo.Trim_Mobile_Phone_Domain(Att_EMA_Email_Address), Att_EMA_Attorney_ID FROM Attorneys_Email_Addresses WHERE Att_EMA_Attorney_ID = @Employee_ID AND Att_EMA_Email_or_Txt_Address='Txt Address'What would be the correct syntax? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-09 : 14:29:10
|
| Is Trim_Mobile_Phone_Domain a scalar udf or table valued?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
freq
Starting Member
17 Posts |
Posted - 2012-02-09 : 15:03:05
|
quote:
Originally posted by visakh16
Is Trim_Mobile_Phone_Domain a scalar udf or table valued?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
It is a scalar udf. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-09 : 15:51:04
|
| What's the error message? Also, let's see the function. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-09 : 17:42:24
|
quote:
Originally posted by freq
quote:
Originally posted by visakh16
Is Trim_Mobile_Phone_Domain a scalar udf or table valued?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
It is a scalar udf.
then there's no error unless it has more parameters and you're not passing themanyways post definition and error as sugested by russell. Then we will be able to make out more------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Need help calling a function from a SQL Server 200