>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 but before that click on Execution plan button (I am sorry I can't tell you right now what button is this, becuase I have only SSMS installend on my computer)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.