Besides, What is the best practise for comparing date? I would like to know whether MAXDOP 1 option will cause process timeout.

I will double check on the decimal issue in if statement expression. What is the best practise for comparing date? Any idea?

what is your recommendation for auto-generated numeric ID? will this cause the wrond returned value?

The returned value I mentioned are just EXAMPLE. The result is in a view of tables. Very hard to show all the fields and values here.

Anyway, here is...

It is not about different order or sorting. The returned results are always the same.

For example the stored procedure should always return the following correct data:

Execute 1st time: AAAAA

Execute...

We still have the problem.

The test was pretty straightforward. We used the same stored procedure and execute in a Virtual Machinese (VMware). We can set whether to use...