2mmQGnVT

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