NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^

[lepitismak]

static can help me on skype?

[marwanayman]

Msg 8101, Level 16, State 1, Line 65
An explicit value for the identity column in table 'Tab_RefTactics' can only be specified when a column list is used and IDENTITY_INSERT is ON.


any idea pls ?

[marwanayman]

client crash before start can I know y ?

[MeTaD]

Well, since the query has some MINOR mistakes, i've decided to find what's going wrong and I found the issue, First, the client crashes because the query says badly the data that has to be in characterdata_45000.txt , the query also says "Copy the following line" and the "spaces" between text must be a "tab" space and not 5 spaces, so, i've fixed that too, and, added a new print to textdata_object (this is for the correct display name in the game of the npc)

USE [SRO_VT_SHARD]
GO
DECLARE  [MENTION=551894]Char[/MENTION]NAME VARCHAR (30)
DECLARE  [MENTION=806871]NPC[/MENTION]NAME VARCHAR (30)
DECLARE  [MENTION=1333458221]Add[/MENTION]NEW VARCHAR (30)
DECLARE @TABNAME VARCHAR (30)
DECLARE @TABNUMBER VARCHAR (30) 
DECLARE @TABNEW VARCHAR (30)
DECLARE  [MENTION=762167]Group[/MENTION]NUMBER VARCHAR (30) 
DECLARE  [MENTION=762167]Group[/MENTION]NEW VARCHAR (30)
DECLARE  [MENTION=21783]Game[/MENTION]WORDID INT

SET  [MENTION=1333458221]Add[/MENTION]NEW = 'NPC' -- 'NPC' to add a new npc, 'TAB' for add a new Tab, 'GROUP' for add a new group!
SET  [MENTION=551894]Char[/MENTION]NAME = 'MeTaD' --U Char Name
SET  [MENTION=806871]NPC[/MENTION]NAME = 'MeTaD NPC' --U NPC NAME
SET  [MENTION=21783]Game[/MENTION]WORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1
SET  [MENTION=762167]Group[/MENTION]NUMBER  = 1
SET @TABNUMBER = 2
SET @TABNAME = 'Items'

--

IF  [MENTION=1333458221]Add[/MENTION]NEW = 'NPC' BEGIN
DECLARE  [MENTION=447213]Max[/MENTION]LINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1
DECLARE  [MENTION=1333395255]Maxcom[/MENTION]MONID VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjCommon)+1
SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country
,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius
,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
(1  [MENTION=1333395255]Maxcom[/MENTION]MONID,'NPC_'  [MENTION=806871]NPC[/MENTION]NAME,'xxx','xxx','SN_NPC_'  [MENTION=806871]NPC[/MENTION]NAME,'xxx',0,1,1,2,2,0,5000,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'npc\npc\chinawoman_Noblegirl_event.bsr','xxx','xxx','xxx','xxx'  [MENTION=447213]Max[/MENTION]LINK)
SET IDENTITY_INSERT _RefObjCommon OFF
SET IDENTITY_INSERT _RefObjChar ON
INSERT INTO _RefObjChar (ID,Lvl,CharGender,MaxHP,MaxMP,ResistFrozen,ResistFrostbite,ResistBurn,ResistEShock,ResistPoison,ResistZombie,ResistSleep,ResistRoot,ResistSlow,ResistFear
,ResistMyopia,ResistBlood,ResistStone,ResistDark,ResistStun,ResistDisea,ResistChaos,ResistCsePD,ResistCseMD,ResistCseSTR,ResistCseINT,ResistCseHP,ResistCseMP,Resist24,ResistBomb,Resist26
,Resist27,Resist28,Resist29,Resist30,Resist31,Resist32,InventorySize,CanStore_TID1,CanStore_TID2,CanStore_TID3,CanStore_TID4,CanBeVehicle,CanControl,DamagePortion,MaxPassenger,AssocTactics,PD,MD,PAR,MAR,ER,BR,HR,CHR
,ExpToGive,CreepType,Knockdown,KO_RecoverTime,DefaultSkill_1,DefaultSkill_2,DefaultSkill_3,DefaultSkill_4,DefaultSkill_5,DefaultSkill_6,DefaultSkill_7,DefaultSkill_8,DefaultSkill_9,DefaultSkill_10,TextureType,Except_1
,Except_2,Except_3,Except_4,Except_5,Except_6,Except_7,Except_8,Except_9,Except_10,Link) VALUES
  [MENTION=447213]Max[/MENTION]LINK,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,336860180,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
SET IDENTITY_INSERT _RefObjChar OFF
SET IDENTITY_INSERT _RefShop ON
DECLARE  [MENTION=373843]shop[/MENTION]ID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShop)+1
INSERT INTO _RefShop (Service,Country,ID,CodeName128,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15  [MENTION=373843]shop[/MENTION]ID,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShop OFF
SET IDENTITY_INSERT _RefShopGroup ON
DECLARE  [MENTION=373843]shop[/MENTION]GroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopGroup)+1
INSERT INTO _RefShopGroup (Service,Country,ID,CodeName128,RefNPCCodeName,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15  [MENTION=373843]shop[/MENTION]GroupID,'GROUP_STORE_'  [MENTION=806871]NPC[/MENTION]NAME,'NPC_'  [MENTION=806871]NPC[/MENTION]NAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShopGroup OFF
SET IDENTITY_INSERT _RefShopItemGroup ON
DECLARE  [MENTION=373843]shop[/MENTION]ItemID VARCHAR (30) = (SELECT MAX (GROUPID) FROM _RefShopItemGroup)+1
INSERT INTO _RefShopItemGroup (Service,GroupID,CodeName128,StrID128_Group)
VALUES (1  [MENTION=373843]shop[/MENTION]ItemID,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1','SN_STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopItemGroup OFF
SET IDENTITY_INSERT _RefShopTab ON
DECLARE  [MENTION=373843]shop[/MENTION]TabID VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15  [MENTION=373843]shop[/MENTION]TabID,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_TAB1','STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1','SN_TAB_WEAPON')
SET IDENTITY_INSERT _RefShopTab OFF
SET IDENTITY_INSERT _RefShopTabGroup ON
DECLARE  [MENTION=373843]shop[/MENTION]TabGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15  [MENTION=373843]shop[/MENTION]TabGroupID,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1','SN_STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopGroup VALUES (1,15,'GROUP_STORE_'  [MENTION=806871]NPC[/MENTION]NAME,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME)
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1')
DECLARE  [MENTION=441621]Tactic[/MENTION]SID INT SET  [MENTION=441621]Tactic[/MENTION]SID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10
INSERT INTO Tab_RefTactics VALUES
  [MENTION=441621]Tactic[/MENTION]SID  [MENTION=1333395255]Maxcom[/MENTION]MONID,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'NPC_'  [MENTION=806871]NPC[/MENTION]NAME)
DECLARE  [MENTION=614210]Hive[/MENTION]ID INT  SET  [MENTION=614210]Hive[/MENTION]ID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
INSERT INTO Tab_RefHive VALUES
  [MENTION=614210]Hive[/MENTION]ID,0,0,0,0,0,0  [MENTION=21783]Game[/MENTION]WORDID,2,'NPC_'  [MENTION=806871]NPC[/MENTION]NAME)
DECLARE  [MENTION=527330]region[/MENTION] VARCHAR (30) SET  [MENTION=527330]region[/MENTION] = (SELECT (LatestRegion) FROM _Char WHERE CharName16 =  [MENTION=551894]Char[/MENTION]NAME)
DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 =  [MENTION=551894]Char[/MENTION]NAME)
DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 =  [MENTION=551894]Char[/MENTION]NAME)
DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 =  [MENTION=551894]Char[/MENTION]NAME)
DECLARE  [MENTION=1333422837]Nesti[/MENTION]D INT SET  [MENTION=1333422837]Nesti[/MENTION]D = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
INSERT INTO Tab_RefNest VALUES
  [MENTION=1333422837]Nesti[/MENTION]D  [MENTION=614210]Hive[/MENTION]ID  [MENTION=441621]Tactic[/MENTION]SID  [MENTION=527330]region[/MENTION],@POSX,@POSY,@POSZ,0,0,0,0,0,0,1,0,1,0)
PRINT 'add this line to characterdata_45000 @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1    '  [MENTION=1333395255]Maxcom[/MENTION]MONID+'    NPC_'  [MENTION=806871]NPC[/MENTION]NAME+'    xxx    xxx    '+'SN_NPC_'  [MENTION=806871]NPC[/MENTION]NAME+'    xxx    0    1    1    2    2    0    5000    3    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    npc\npc\chinawoman_Noblegirl_event.bsr    xxx    xxx    xxx    xxx    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    336860180    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0'
PRINT ''
PRINT 'Add this line to refshop.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1    15    '  [MENTION=373843]shop[/MENTION]ID+'    '+'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
PRINT ''
PRINT 'Add this line to refshopgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1    15    '  [MENTION=373843]shop[/MENTION]GROUPID+'    '+'GROUP_STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'    '+'NPC_'  [MENTION=806871]NPC[/MENTION]NAME+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
PRINT ''
PRINT 'Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1    '  [MENTION=373843]shop[/MENTION]ITEMID+'    '+'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1    '+'SN_STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to refshoptab.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1    15    '  [MENTION=373843]shop[/MENTION]TABID+'    '+'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_TAB1    '+'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1    SN_TAB_WEAPONS'
PRINT ''
PRINT 'Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1    15    '  [MENTION=373843]shop[/MENTION]TABGROUPID+'    '+'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1    '+'SN_STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1    15    '+'GROUP_STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'    '+'STORE_'  [MENTION=806871]NPC[/MENTION]NAME
PRINT ''
PRINT 'Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1    15    '+'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'    '+'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to textdata_object @ server_dep\silkroad\textdata'
PRINT ''
print '1    SN_NPC_'  [MENTION=806871]NPC[/MENTION]NAME+'                                '  [MENTION=806871]NPC[/MENTION]NAME
print ''
PRINT 'A New NPC Has ADD Succesfuly Restart U Server and Login in '  [MENTION=551894]Char[/MENTION]NAME
END
IF @TABNUMBER = 2 SET @TABNEW = 'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_TAB2'
IF @TABNUMBER = 3 SET @TABNEW = 'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_TAB3'
IF @TABNUMBER = 4 SET @TABNEW = 'STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'_TAB4'
IF  [MENTION=762167]Group[/MENTION]NUMBER  = 2 SET  [MENTION=762167]Group[/MENTION]NEW = '_GROUP2'
IF  [MENTION=762167]Group[/MENTION]NUMBER  = 3 SET  [MENTION=762167]Group[/MENTION]NEW = '_GROUP3'
IF  [MENTION=762167]Group[/MENTION]NUMBER  = 4 SET  [MENTION=762167]Group[/MENTION]NEW = '_GROUP4'
IF  [MENTION=762167]Group[/MENTION]NUMBER  = 5 SET  [MENTION=762167]Group[/MENTION]NEW = '_GROUP5'
IF  [MENTION=762167]Group[/MENTION]NUMBER  = 6 SET  [MENTION=762167]Group[/MENTION]NEW = '_GROUP6'
IF  [MENTION=1333458221]Add[/MENTION]NEW = 'GROUP' BEGIN 
SET IDENTITY_INSERT _RefShopTabGroup ON
SET  [MENTION=373843]shop[/MENTION]TabGroupID = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15  [MENTION=373843]shop[/MENTION]TabGroupID,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME  [MENTION=762167]Group[/MENTION]NEW,'SN_STORE_'  [MENTION=806871]NPC[/MENTION]NAME  [MENTION=762167]Group[/MENTION]NEW)
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME  [MENTION=762167]Group[/MENTION]NEW)
PRINT ''
PRINT 'New Group Added Succesfully '
PRINT 'add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT '1    15    '  [MENTION=373843]shop[/MENTION]TABGROUPID+'    STORE_'  [MENTION=806871]NPC[/MENTION]NAME  [MENTION=762167]Group[/MENTION]NEW+'    SN_STORE_'  [MENTION=806871]NPC[/MENTION]NAME  [MENTION=762167]Group[/MENTION]NEW
PRINT ''
PRINT 'add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT '1    15    STORE_'  [MENTION=806871]NPC[/MENTION]NAME+'    STORE_'  [MENTION=806871]NPC[/MENTION]NAME  [MENTION=762167]Group[/MENTION]NEW

END

IF  [MENTION=1333458221]Add[/MENTION]NEW = 'TAB' BEGIN
IF  [MENTION=762167]Group[/MENTION]NUMBER = 1 SET  [MENTION=762167]Group[/MENTION]NEW = '_GROUP1'
SET IDENTITY_INSERT _RefShopTab ON
SET  [MENTION=373843]shop[/MENTION]TabID = (SELECT MAX (ID) FROM _RefShopTab)+1
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15  [MENTION=373843]shop[/MENTION]TabID,@TABNEW,'STORE_'  [MENTION=806871]NPC[/MENTION]NAME  [MENTION=762167]Group[/MENTION]NEW,'SN_'+@TABNAME)
SET IDENTITY_INSERT _RefShopTab OFF
PRINT ''
PRINT 'New Tab added Sucessfully add this new line to refshoptab.txt @ server_dep\silkroad\textdata' 
PRINT '1    15    '  [MENTION=373843]shop[/MENTION]TABID+'    STORE_'  [MENTION=806871]NPC[/MENTION]NAME+@TABNEW+'    STORE_'  [MENTION=806871]NPC[/MENTION]NAME  [MENTION=762167]Group[/MENTION]NEW+'    SN_TAB_'+@TABNAME
END
IF @TABNUMBER > 4 BEGIN
PRINT '@TABNUMBER value does not exist. u must add 2 , 3 OR 4 Tabs Per NPC!'
END
IF  [MENTION=762167]Group[/MENTION]NUMBER > 8 BEGIN
PRINT   [MENTION=762167]Group[/MENTION]NUMBER value does not exist. u must add  1 , 2 , 3 , 4 , 5 , 6 , 7 OR 8 Groups!'
END
IF  [MENTION=1333458221]Add[/MENTION]NEW = '' BEGIN
PRINT   [MENTION=1333458221]Add[/MENTION]NEW value does not exist. u must set values NPC , TAB , GROUP'
END
/******************************* Best Query By Statiic don't Re-Release Under u Name*******************************/ 

HATE DE FUCKING "[MENTION=" of the forum

See ATACHMENT FOR THE WORKING SQL

[JairValerio]

Client in crash , Helpmeee !

[EslamGalal]

Done all indetiy and still give this

Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '+'.
Msg 102, Level 15, State 1, Line 12
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 12
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 25
Must declare the scalar variable "@MAXLINK".
Msg 102, Level 15, State 1, Line 28
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 28
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 30
Must declare the scalar variable "@ShopID".
Msg 102, Level 15, State 1, Line 33
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 33
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 35
Must declare the scalar variable "@ShopGroupID".
Msg 102, Level 15, State 1, Line 38
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 38
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 40
Must declare the scalar variable "@ShopItemID".
Msg 102, Level 15, State 1, Line 43
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 43
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 45
Must declare the scalar variable "@ShopTabID".
Msg 102, Level 15, State 1, Line 48
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 48
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 50
Must declare the scalar variable "@ShopTabGroupID".
Msg 137, Level 15, State 2, Line 56
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 73
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 77
Must declare the scalar variable "@SHOPID".
Msg 137, Level 15, State 2, Line 81
Must declare the scalar variable "@SHOPGROUPID".
Msg 137, Level 15, State 2, Line 85
Must declare the scalar variable "@SHOPITEMID".
Msg 137, Level 15, State 2, Line 89
Must declare the scalar variable "@SHOPTABID".
Msg 137, Level 15, State 2, Line 93
Must declare the scalar variable "@SHOPTABGROUPID".

Sorry im still a beginner ^^

Sql 2005
Done all ID Keys > Yes !

[Razor1337]

Working as well thanks for sharing :)

[omarkabo]

Very Thanks ^_^

[glennhollanda]

please i wish any one could make a little youtube clip about it