I have faced a different problem recently.
When i executed a procedure from back end, it works fine.
But when i executed the same procedure from UI, it is not giving the proper result.
I also identified the problem.
The problem is
i have one condition in my procedure. The procedure will get value from the front end.
If ( @MID = Null and @sP = Null and @ACls = Null and @SId = Null and @SDetId = Null)
which I changed to this
If ( @MID is Null and @sP is Null and @ACls is Null and @SId is Null and @SDetId is Null)
then it works fine from UI.
I remember one rule about NULL. Two nulls are not equal.
I also have studied an article here about Difference between =NULL and IS NULL. In that article he mentioed about vtable ( to store table variables). As i want to know more about it,I have searched on websites, but i can't get any clear information.
It would be appreciated if anyone give more information on that.