Weird Error

[Onyxpurr]

Has anybody had this happen?

I have two stored procedures pretty close in code to each other.

Both were returning errors when I ran them from Access in a pass-through query. The error stated something like unable to convert char to datetime.

I checked my code and didn't have any instance in which I was doing that.

So I dropped one proc and then debugged by cut and pasting each time I created it. No problems each time I pasted a little bit more. Eventually I pasted the whole thing with no changes and it ran fine.

So I decided to check the other stored proc from Access and it ran fine too. What the heck?!

Does anyone have a suggestion as to what happened? I'm running SQL Server 7.0 and MS Access 2000.

 

[rac2]

That kind of error can be due to bad data in a single row of a table with otherwise good data. It is not necessarily a syntax error.