Question Locked

Invalid Object Name Error - Scalar Function

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a scalar valued function that uses the following parameters:
@birthmonthnum,@birthdaynum and @birthyearnum

I can run the function if I use:
select dbo.fnc_GetBirthDate (6,21,1959)as birthdate

But if I try to join with another table using:
SELECT * FROM cv3client c CROSS APPLY dbo.fnc_GetBirthDate (c.birthmonthnum,c.birthdaynum,c.birthyearnum)
I get the following error:
Invalid object name 'dbo.fnc_GetBirthDate'.

Any help would be appreciated.

1 reply

This discussion is closed to new replies.