Rank problem

[vovan681]

Help solve the problem with this.
Sorry for my English

 Spoiler

2016-03-15 01:24:57 PS_DBAGENT__system log start (DBAgent01)

Module list:

G:\PSM_Client\Bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2016-03-15 01:25:07 ### Connect[572] : Game[?][0x0125BBB8], Addr=127.0.0.1, DBJobEnd=1

2016-03-15 01:25:07 ### DB_SYSTEM_CONNECT[4316] :Game[1][0x0125BBB8], Name=Game01, Addr=127.0.0.1

2016-03-15 01:25:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Недопустимое имя столбца "Rank"., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2016-03-15 01:25:07 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2016-03-15 01:25:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Недопустимое имя столбца "Rank"., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2016-03-15 01:25:07 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2016-03-15 01:25:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Недопустимое имя столбца "Rank"., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2016-03-15 01:25:07 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

[AxelMac]

Try this script

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_Guild2_R] Script Date: 10/12/2012 11:56:06 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO






ALTER Proc [dbo].[usp_Read_Guild2_R]

AS

SET NOCOUNT ON

SELECT G.GuildID, G.GuildName, G.MasterName, G.Country, G.GuildPoint,
ISNULL(H.[Rank],31) [Rank], ISNULL(H.Etin,0) Etin, ISNULL(H.UseHouse,0) UseHouse, ISNULL(H.Remark, '') Remark, ISNULL( H.BuyHouse,0) BuyHouse, ISNULL(H.EtinReturnCnt, 0 ) EtinReturnCnt, ISNULL(H.KeepEtin, 0) KeepEtin
FROM Guilds G
LEFT OUTER JOIN GuildDetails H ON G.GuildID = H.GuildID
WHERE G.Del=0
ORDER BY H.[Rank] DESC

SET NOCOUNT OFF