I encountered a problem which the result different compare in query analyzer with result calling from user-defined function. I describe more on my problem. I have a stored procedure name SP1 and a user-defined function name Function1.
When I copy out the Function1 run in query analyzer, the result is as my expected. While when the SP1 call Function1, the result is wrong. And I double check the code at both side are same. And even I copy the code at query analyzer which return correct result to the Function1. But the result still wrong.
Anyone know why?
View Complete Post