Forum Discussion
Advocate IIIStored Procedure error
Hi rmcgrath
This typically occurs when:
A date value is outside SQL Server's valid range (January 1, 1753 to December 31, 9999)
There's a type mismatch in date handling
The stored procedure receives malformed date parameters
Check:
-the date parameters. Try this modified version:
EXEC dbo.spGetDailyLivPct @PDStrDate = '20240101', -- ISO format (YYYYMMDD) @PDEndDate = '20250611'
- for NULL Dates in Source Data
- for Invalid Dates in Results. The error might come from the result set. Try limiting columns
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
Solution SageHi rmcgrath
This typically occurs when:
A date value is outside SQL Server's valid range (January 1, 1753 to December 31, 9999)
There's a type mismatch in date handling
The stored procedure receives malformed date parameters
Check:
-the date parameters. Try this modified version:
EXEC dbo.spGetDailyLivPct @PDStrDate = '20240101', -- ISO format (YYYYMMDD) @PDEndDate = '20250611'
- for NULL Dates in Source Data
- for Invalid Dates in Results. The error might come from the result set. Try limiting columns
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.