[#3mr]

اول حاجه شوف الى هتبعته مفتوح فى RefObjCommen
ولا لا
وبعدين

اعمل الكيورى ده الاول

DECLARE    @CharName VARCHAR(64), 
    @GuildID VARCHAR(64) 
DECLARE    @ItemCodeName VARCHAR(64) = 'Item Code' 

DECLARE item_cur CURSOR FOR  
SELECT DISTINCT CharName FROM ___FortressReward ORDER BY CharName 

    OPEN item_cur  
        FETCH NEXT FROM item_cur INTO @CharName  
            WHILE @@FETCH_STATUS = 0  
                BEGIN  
                    EXEC _ADD_ITEM_EXTERN @CharName, @ItemCodeName, 20, 1 
                    FETCH NEXT FROM item_cur INTO @CharName  
                END  
          
        PRINT @CharName  
    CLOSE item_cur  

DEALLOCATE item_cur

اعمل تابل باسم FortressReward__

واضرب الكيورى ده

USE [SRO_VT_SHARD] 
GO 

/****** Object:  Table [dbo].[___FortressReward]    Script Date: 9/23/2014 5:31:53 AM ******/ 
SET ANSI_NULLS ON 
GO 

SET QUOTED_IDENTIFIER ON 
GO 

SET ANSI_PADDING ON 
GO 

CREATE TABLE [dbo].[___FortressReward]( 
    [GuildID] [int] NOT NULL, 
    [CharID] [int] NOT NULL, 
    [CharName] [varchar](64) NOT NULL, 
    [MemberClass] [tinyint] NOT NULL, 
    [CharLevel] [tinyint] NOT NULL, 
    [GP_Donation] [int] NOT NULL, 
    [JoinDate] [smalldatetime] NOT NULL, 
    [Permission] [int] NULL, 
    [Contribution] [int] NULL, 
    [GuildWarKill] [int] NULL, 
    [GuildWarKilled] [int] NULL, 
    [Nickname] [varchar](64) NULL, 
    [RefObjID] [int] NULL, 
    [SiegeAuthority] [tinyint] NULL, 
 CONSTRAINT [PK_______GuildMember] PRIMARY KEY CLUSTERED  
( 
    [GuildID] ASC, 
    [CharID] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] 
) ON [PRIMARY] 

GO 

SET ANSI_PADDING OFF 
GO 

ALTER TABLE [dbo].[___FortressReward] ADD  DEFAULT ((0)) FOR [RefObjID] 
GO 

ALTER TABLE [dbo].[___FortressReward] ADD  DEFAULT ((0)) FOR [SiegeAuthority] 
GO

اسم الجيلد عن طريق id

Select * From _Guild Where Name = 'GuildName'

Select * From _GuildMember Where GuildID = 'GuildID'