Originally Posted by
Cherti
Problem in procedure, run this query to fix it:
Code:
USE [atum2_db_1]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[atum_admin_GetCharacterByCharacterName]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[atum_admin_GetCharacterByCharacterName]
GO
USE [atum2_db_1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[atum_admin_GetCharacterByCharacterName]
@i_CharName VARCHAR(20)
AS
-- // 2007-07-30 by cmkwon, SCAdminTool¿¡¼ ¿©´Ü¸í º¯°æ ±â´É ?ß°¡ - ij¸¯ÅÍ Á¤º¸¸¦ °¡Á®¿?¶§ td_Guild Å×À?ºíÀ» ÂüÁ¶ÇÏ¿© ¾÷µ¥À?Æ®ÇÑ À?ÈÄ¿¡ °¡Á®¿Â´Ù
IF NOT EXISTS(SELECT c.UniqueNumber FROM td_character c, td_guild g, td_guildMember gm WITH(NOLOCK) WHERE c.charactername = @i_CharName AND c.GuildUniqueNumber = g.GuildUniqueNumber AND gm.GuildUniqueNumber = c.GuildUniqueNumber AND gm.CharacterUniqueNumber = c.UniqueNumber)
BEGIN
UPDATE td_character
SET GuildName = NULL, GuildUniqueNumber = 0
FROM td_character c WITH (NOLOCK)
WHERE c.charactername = @i_CharName
END
ELSE
BEGIN
UPDATE td_character
SET GuildName = g.GuildName
FROM td_character c, td_Guild g WITH (NOLOCK)
WHERE c.charactername = @i_CharName AND c.GuildUniqueNumber = g.GuildUniqueNumber
END
SELECT *
FROM td_Character
WITH (NOLOCK)
WHERE charactername = @i_CharName
GO
Reply With Quote