0LRQfNjG

1
2if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KNIGHTS_RATING_UPDATE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
3drop procedure [dbo].[KNIGHTS_RATING_UPDATE]
4GO
5
6
7/****** Object:  Stored Procedure dbo.KNIGHTS_RATING_UPDATE    Script Date: 6/6/2006 6:03:32 PM ******/
8
9-- Created By Sungyong 2002. 10. 14
10
11CREATE PROCEDURE KNIGHTS_RATING_UPDATE AS
12
13if exists (select * from sysobjects where id = object_id(N'[dbo].[rating_temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
14drop table [dbo].[rating_temp]
15CREATE TABLE [dbo].[rating_temp] (
16	[nRank] [int] IDENTITY (1, 1) NOT NULL ,
17	[shIndex] [smallint] NULL,
18	[strName] [char] (21) NULL ,
19	[nPoints] [int] NULL ,
20) ON [PRIMARY]
21
22
23INSERT INTO rating_temp SELECT IDNum, IDName, Points FROM KNIGHTS ORDER BY Points DESC
24
25CREATE  INDEX [IX_rating_rank] ON [dbo].[rating_temp]([nRank]) ON [PRIMARY]
26CREATE  INDEX [IX_rating_name] ON [dbo].[rating_temp]([strName]) ON [PRIMARY]
27
28if exists (select * from sysobjects where id = object_id(N'[dbo].[KNIGHTS_RATING]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
29drop table [dbo].[KNIGHTS_RATING]
30EXEC sp_rename 'rating_temp','KNIGHTS_RATING'
31GRANT SELECT ON KNIGHTS_RATING TO web
32
33GO
34SET QUOTED_IDENTIFIER OFF 
35GO
36SET ANSI_NULLS ON 
37GO
38
39SET QUOTED_IDENTIFIER ON 
40GO
41SET ANSI_NULLS ON 
42GO