|
รัน query produce sp.extreme ครับ
- USE [RanGame1]
- GO
- /****** Object: StoredProcedure [dbo].[sp_Extreme] Script Date: 12/17/2010 05:33:37 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER PROCEDURE [dbo].[sp_Extreme]
- @nUserNum int
- AS
- DECLARE
- @error_var int,
- @rowcount_var int
- SET NOCOUNT ON
- Select 9 As M, 9 As F
- From
- (
- Select isnull(Sum(M),1) As MSum, isnull(Sum(F),1) As FSum, isnull(Sum(MS),0) As MS, isnull(Sum(FS),0) As FS
- From
- (
- Select ChaClass
- ,
- Case ChaClass
- When 1 Then 1
- When 2 Then 1
- When 256 Then 1
- When 512 Then 1
- Else 0
- End As M
- ,
- Case ChaClass
- When 4 Then 1
- When 8 Then 1
- When 64 Then 1
- When 128 Then 1
- Else 0
- End As F
- ,
- Case ChaClass
- When 16 Then
- Case ChaDeleted
- When 1 Then 0
- Else 1
- End
- Else 0
- End As MS
- ,
- Case ChaClass
- When 32 Then
- Case ChaDeleted
- When 1 Then 0
- Else 1
- End
- Else 0
- End As FS
- From ChaInfo Where UserNum=@nUserNum And (
- ( ChaClass=16 OR ChaClass=32 ) OR
- ( ( ChaClass=1 OR ChaClass=2 OR ChaClass=4 OR ChaClass=8 OR
- ChaClass=64 OR ChaClass=128 OR ChaClass=256 OR ChaClass=512 ) AND ChaLevel>=0 ) )
- ) As t
- ) As tt
คัดลอกไปที่คลิปบอร์ด |
|