Rate Post

Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author

Message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 143890
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0

Posted on Thursday, October 15, 2015 - 10:12 am:

UPDATE t1
SET t1.col2 = 10 * (t2.col1 + t2.col2)
FROM theTable t1
INNER JOIN theTable t2 ON t1.busRelAccount = t2.busRelAccount
WHERE

t1.rowName = 'INVENTORY'
AND t2.rowName = 'POS'
;

ata... CLIPART--5run

Administration