>That works perfect.
>How do I check the time reqd to execute the query (or any other way to check the performance enhancement).
>
>If I want to add a runbalance calculated field for the same query how do I do it ?
>(sorry this should be new question)
>
>Rajesh
Run this query in QA and after that click on Display Estimated Execution plan button (ctrl+L).
Take a look at ToolTips in bottom window where is the Result of execution plan.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst