Forum Discussion
Stored Procedure error
Ok, no everything I have tried continues to produce the following error:
Here is the stored procedure I am trying to execute:
What am I doing wrong? I don't understand the "datetime" 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.
1 Reply
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.