Invalid Object Name

Ramco Ramco

3y834SQL

I have below code &it is giving above error. Functions exists

,(select count(*) from [dbo].[Fun_GetBookReturnStatus](B.[ID],GP.[StudentID]))

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty3y ago
Accepted answer
Try to store the fubction value in a variable and then use it.
```
DECLARE @bookReturnCount INT = (SELECT COUNT(*) FROM [dbo].[Fun_GetBookReturnStatus](B.[ID],GP.[StudentID])
```
Use it like ,ISNULL(@bookReturnCount,'') [BookReturnStatus].
Ramco Ramco3y ago
Hi AMit

Below line is also in the procedure & it is working

,ISNULL([dbo].[Fun_GetBookReturnStatus](B.[ID],GP.[StudentID]),'') [BookReturnStatus].

I want to get count of records returned by Function

Thanks
Amit Mohanty3y ago
One possible reason for the error could be that the user-defined function Fun_GetBookReturnStatus does not exist in the current database or the input parameters provided to the function are invalid or not of the expected data type.