Dear all,

I got a complaint about a SP which I don't understand. Normally, the result of the SP matches the data-representation in the database. I now have a situation in the production database where this is not the case. On my test-database it works Oke.

If the SQL statements are executed in MS-SQL the results are Oke.
If I strip the SP and replace the parameters given to the SP and run it in MS-SQL the results are Oke.
However, if the SP is executed in MS-SQL and the same parameters are specified, I get a different result.

Who has had similar probems?
Who can give any suggestions?

I'm running on SQL Server 6.50 - 6.50.258 (Intel X86) (Sp3)

Greetings,
Jody