Dev.Ri3o
05-11-2015, 12:45 PM
http://www3.0zz0.com/2015/10/31/09/352673002.gif (https://www.0zz0.com)
...
http://www3.0zz0.com/2015/10/31/09/245477174.gif (https://www.0zz0.com)
...
النهارده جايبلكو Quey عشان تحدد نسبة ال Gold In Job Rate
http://www3.0zz0.com/2015/11/07/10/771791019.gif (https://www.0zz0.com)
USE [SRO_VT_SHARD] ----Query By [GM]Ri3o---
DECLARE @NewQuot FLOAT
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 2.0 -- هنا تحط النسبة بتاعتك ---
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
.................................................. ........................
http://www3.0zz0.com/2015/11/07/10/771791019.gif (https://www.0zz0.com)
اللون اللى بالاحمر هو ده ال نسبة مثلا
2x=2.0 1.5x=1.5 3x=3.0
http://www3.0zz0.com/2015/10/31/09/389478075.gif (https://www.0zz0.com)
...
http://www3.0zz0.com/2015/10/31/09/245477174.gif (https://www.0zz0.com)
...
النهارده جايبلكو Quey عشان تحدد نسبة ال Gold In Job Rate
http://www3.0zz0.com/2015/11/07/10/771791019.gif (https://www.0zz0.com)
USE [SRO_VT_SHARD] ----Query By [GM]Ri3o---
DECLARE @NewQuot FLOAT
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 2.0 -- هنا تحط النسبة بتاعتك ---
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
.................................................. ........................
http://www3.0zz0.com/2015/11/07/10/771791019.gif (https://www.0zz0.com)
اللون اللى بالاحمر هو ده ال نسبة مثلا
2x=2.0 1.5x=1.5 3x=3.0
http://www3.0zz0.com/2015/10/31/09/389478075.gif (https://www.0zz0.com)