I need to run this script to update the value of 3 columns based on certain conditions. Right now, this is what I have:
UPDATE dbo.Roles SET DisplayName = Name WHERE DisplayName LIKE ''; UPDATE dbo.Roles SET Name = CONCAT(Tenant, '_', DisplayName) WHERE Name NOT LIKE ('%' + Convert(varchar(200), Tenant) + '%'); UPDATE dbo.Roles SET NormalizedName = CONCAT(Tenant, '_', UPPER(DisplayName)) WHERE NormalizedName NOT LIKE ('%' + Convert(varchar(200), Tenant) + '%');
I'm doing this with 3 separate update statements. I can't help but think there's probably a better way, but maybe I'm overthinking. Any suggestions?