jVzrNvH1

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