>>>Dear Experts,
>>>I am using these codes.
>>>The codes work fine, no issue.
>>>
>>>Is it possible to make the code shorten for speed?
>>>
>>
>>What does SYS(3054) tell you?
>>
>>http://www.tomorrowssolutionsllc.com/Articles/Make%20Your%20Queries%20Fly.pdf
>>http://www.tomorrowssolutionsllc.com/Articles/Speed%20Up%20Your%20SQL%20Code.pdf
>
>probably not much in this case (look up at engine entry...)

Ah, yeah, missed that.

Tamar