WOW! Thanks for your help. It solve my problem.

jwlooi

Kingston Dhasian (9/11/2013)

---

One of the ways to achieve it..

DECLARE@tableSTK TABLE

(

ItemIDVARCHAR(8),

ItemDescVARCHAR(100),

PriceMONEY

)

DECLARE @tableABC TABLE

(

ItemIDVARCHAR(8),

ConditionAmtMONEY,

Return_AmtMONEY

)

INSERT@tableSTK

( ItemID, ItemDesc,...