>>I'm stumped by the error in the title on the 2nd line. I catched this in the error log at a clients, so no repro.
>>Its intermittend.
>>
>>

SELECT InvestLimits
>>SET ORDER TO Itemid

>>
>>
>>There is no variable called Investlimits, just an alias. The first line has no problem, but it bangs on the SET ORDER TO ItemID.
>>
>>Anyone have an idea?
>
>May be timer switches the currently selected area. I suggest to add set order to ItemId in InvestLimits - this will prevent such error

A timer between two lines seems very unlikely to me.