Loading

how to update column value in sqlserever

Devendra Kumar

10y886

hi friends please help me :

i want to update my product price

Select a.Category_Name, b.Price,c.Qty,b.Price_Updated_by,

case when b.Price_Updated_by = 'Product' then b.Price*c.Qty

else a.cat_price*c.Qty end as[TotalPrice],

i want i check

case when a.Category_Name='Bedsheet Tapestry' then b.Price='60',

i want b.price =60 when category name Bedsheet Tapestry

what it is possible please help

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Laxmikanth O10y ago
You need to write UPDATE statement with Joins.. Here is the link for the reference.
http://blog.sqlauthority.com/2013/04/30/sql-server-update-from-select-statement-using-join-in-update-statement-multiple-tables-in-update-statement/