شباب ابي سكربت

ابي سكربت يزود خبرة المرافقيت و أخر يخلي نسبة نجاح تطوير الحزام 100 %

ثواني اجيبه

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = 1
WHERE [percentage_1] > 0 or [percentage_1] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = 1
WHERE [percentage_2] > 0 or [percentage_2] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = 1
WHERE [percentage_3] > 0 or [percentage_3] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = 1
WHERE [percentage_4] > 0 or [percentage_4] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = 1
WHERE [percentage_5] > 0 or [percentage_5] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = 1
WHERE [percentage_6] > 0 or [percentage_6] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = 1
WHERE [percentage_7] > 0 or [percentage_7] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = 1
WHERE [percentage_8] > 0 or [percentage_8] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = 1
WHERE [percentage_9] > 0 or [percentage_9] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = 1
WHERE [percentage_10] > 0 or [percentage_10] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_11] = 1
WHERE [percentage_11] > 0 or [percentage_11] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_12] = 1
WHERE [percentage_12] > 0 or [percentage_12] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_13] = 1
WHERE [percentage_13] > 0 or [percentage_13] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_14] = 1
WHERE [percentage_14] > 0 or [percentage_14] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_15] = 1
WHERE [percentage_15] > 0 or [percentage_15] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_16] = 1
WHERE [percentage_16] > 0 or [percentage_16] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_17] = 1
WHERE [percentage_17] > 0 or [percentage_17] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_18] = 1
WHERE [percentage_18] > 0 or [percentage_18] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_19] = 1
WHERE [percentage_19] > 0 or [percentage_19] = 0
GO


UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_20] = 1
WHERE [percentage_20] > 0 or [percentage_20] = 0
GO


update [arcadia].[dbo].[EnhanceResource]
set [fail_result] = 0
where [fail_result] > 3 or [fail_result] >2 or [fail_result] >1
or [fail_result] = 3 or [fail_result] = 2 or [fail_result] = 1
fail_result means it cant break, for the other you can set it the way you want

مشكور