Invalid Object Name Error - Scalar Function - TechRepublic
Question
February 2, 2010 at 08:22 AM
9iron

Invalid Object Name Error – Scalar Function

by 9iron . Updated 16 years, 5 months ago

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 discussion is locked

All Comments