Hi,

Please find the query to update the cty to 'A' where cty is 'B' and from cty 'B' to 'A'.

BEGIN TRAN

SELECT *FROM CITY

UPDATE CITY

SET CTY = CASE WHEN CTY...

Hi,

Please find the query that will delete the record for ConsumerID = 99 from table A.

BEGIN TRAN

SELECT * FROM TableA

Delete TableA from TableA a

where ConsumerID = 99 and

exists(select 1...