Everything you need to know about backup and disaster recovery with AWS, for FREE!
DECLARE @sw1 int, @sw2 int, @sw3 int; UPDATE dbo.New_Products_To_Add SET @sw1 = CASE WHEN dc_custom_physical_weight_1 > dc_custom_dimensional_weight_1 THEN dc_custom_physical_weight_1 ELSE dc_custom_dimensional_weight_1 END; UPDATE dbo.New_Products_To_Add SET @sw2 = CASE WHEN dc_custom_physical_weight_2 > dc_custom_dimensional_weight_2 THEN dc_custom_physical_weight_2 ELSE dc_custom_dimensional_weight_2 END; UPDATE dbo.New_Products_To_Add SET @sw3 = CASE WHEN dc_custom_physical_weight_3 > dc_custom_dimensional_weight_3 THEN dc_custom_physical_weight_3 ELSE dc_custom_dimensional_weight_3 END; UPDATE dbo.New_Products_To_Add SET weight = @sw1 + @sw2 + @sw3
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Duplicated data in GROUP_CONCAT||2||49|
|Display field if column exists||7||58|
|calculate days away||11||61|
|Question on sending emails using SQL Server 2008 R2 database mail||10||55|
Join the community of 500,000 technology professionals and ask your questions.