How to loop a table column and create conditional insert statement in mssql

Question

I want to loop CustomerType column in CustomerDetails table. then use the condition where CustomerType = 'CorporateCustomer' to update IsCorporateCustomer column to 1 and else update others to 0

This is what I did but It only executes the first statement and added 1 to all the IsCorporateCustomer column.

How can I fix this? Thanks

IF EXISTS (SELECT * FROM CustomerDetails WHERE CustomerType =  'CorporateCustomer')
BEGIN
UPDATE CustomerDetails set IsCorporateCustomer = 1;
END
ELSE
BEGIN
UPDATE CustomerDetails set IsCorporateCustomer=0;
END

Why not UPDATE CustomerDetails SET IsCorporateCustomer=1 WHERE CustomerType = 'CorporateCustomer' — Sergey
– Sergey, Commented Jan 25, 2021 at 14:51

eshirvana · Accepted Answer · 2021-01-25 14:50:15Z

2

you can use case statement, so your whole statement above will be as simple as below query:

UPDATE CustomerDetails 
set IsCorporateCustomer = case when CustomerType =  'CorporateCustomer' then 1 else 0 end;

answered Jan 25, 2021 at 14:50

eshirvana

24.7k3 gold badges28 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to loop a table column and create conditional insert statement in mssql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related