August 24, 2021 at 6:50 pm
Hi all,
We've got a stored procedure with a single date parameter. When I run the query inside the proc (just commenting out the Alter/Create statement and hardcoding the date parameter) I get all records returned.
However when I run it as a stored proc passing the same date parameter I'm missing 4 records in the resultset. I'm at my wits end trying to figure what the difference is.
Any help in figuring this out is appreciated.
August 24, 2021 at 8:19 pm
Not much we can go on - would help if you showed the code that is causing the issue.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 24, 2021 at 8:32 pm
I figured out the answer, and I had the code, but at 580 lines I got rid of it. I couldn't figure out how to delete the question.
August 24, 2021 at 8:43 pm
Share what you found, and help others learn.
Sooner or later ,someone else out there will be struggling with a similar problem, and your experience may help them.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply