Invalid Object Name Error - Scalar Function

By 9iron ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums