Thanks!

Yes, What I want is in final table to have account, symbol and pnl depending on the size. PnL corresponding to trade quantity less that 1000, 1000 - 10000 and...

Thank you!!! Wow that works great!

If I want to divide into different buckets by size for example <1000, 1000-10,000 and >10000. Whats the best way to do this.

Thanks again...

Oops I posted a wrong query.

Working query:

select sum(convert(int, A.exeQty))/2 from

(select RPM.Account, RPM.Symbol, RPM.PandL, RMM.exeQty, RMM.Side, RMM.Creation_Date

from Redi_Position_Monitor RPM, Redi_Message_Monitor RMM

where

RPM.Position = 0 and

RPM.Symbol = RMM.Symbol and

RPM.Account =...

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (...)

Thanks Lynn Pettis for the alignment.

Here is what I have done, I am sure there is much better way of doing it. Since I am used to matlab I wrote is similar style.

CREATE PROCUDURE...