Thx For Reply,

This problems have been solved with the assist of all you guys, especially Ramesh.

Thx Very Much.

M.F.R

Thanks Ramesh,

i've little complex validation (maybe just for me :-)),one of them is :

i want to populate data on table TmpMasterAR with data from table MasterAR.

--MasterAR Table

select

MasterARStoreID StoreID,

MasterARTgl Date,...

Thanks for reply,

in this situation, i want to do some validation on each record being returned by sql

statement before storing the values into destination table.

should i use temporary table...