Script Disable or Enable Extreme Class

acehood88

1. USE [RanGame1]
   
2. GO
   
3. /****** Object: StoredProcedure [dbo].[sp_Extreme] Script Date: 08/24/2010 15:08:45 ******/
   
4. SET ANSI_NULLS ON
   
5. GO
   
6. SET QUOTED_IDENTIFIER ON
   
7. GO
   
8. -- 必碍何 巢/咯 积己 肮荐甫 馆券茄促.
   
9. ALTER PROCEDURE [dbo].[sp_Extreme] @NuserNum int
   
10. 
    
11. AS
    
12. DECLARE @ERROR_var int, @Rowcount_var int
    
13. 
    
14. SET NOCOUNT ON
    
15. Select (MSum-MS) As M, (FSum-FS) As F
    
16. From
    
17. (
    
18. Select isnull(Sum(M),0) As MSum, isnull(Sum(F),0) As FSum, isnull(Sum(MS),0) As MS, isnull(Sum(FS),0) As FS
    
19. From
    
20. (
    
21. Select ChaClass
    
22. ,
    
23. Case ChaClass
    
24. When 1 Then 1<<<---0 change to zero
    
25. When 2 Then 1<<<---0 change to zero
    
26. When 256 Then 1<<<---0 change to zero
    
27. When 512 Then 1<<<---0 change to zero
    
28. Else 0
    
29. End As M
    
30. ,
    
31. Case ChaClass
    
32. When 4 Then 1
    
33. When 8 Then 1
    
34. When 64 Then 1
    
35. When 128 Then 1
    
36. Else 0
    
37. End As F
    
38. ,
    
39. Case ChaClass
    
40. When 16 Then
    
41. Case ChaDeleted
    
42. When 4 Then 0
    
43. Else 1
    
44. End
    
45. Else 0
    
46. End As MS
    
47. ,
    
48. Case ChaClass
    
49. When 32 Then
    
50. Case ChaDeleted
    
51. When 4 Then 0
    
52. Else 1
    
53. End
    
54. Else 0
    
55. End As FS
    
56. From ChaInfo
    
57. ) As t
    
58. ) As tt

คัดลอกไปที่คลิปบอร์ด

zawarrior

โอ้วว ชอบบบขอบคุณครับ

PUNPUN

ขอบคุณครับ เดี๋ยวพรุ่งนี้รายงานผลครับ