ٍSQL Experts

[Mc-Diesel]

Wanna Make This Query Added multiple Value To make it Easier to Add Full Degree As A Drop

USE/**/[SRO_VT_SHARD]/**/

GO
DECLARE  [MENTION=614520]mob[/MENTION] VarChar(MAX)  [MENTION=1134588]item[/MENTION] VarChar(MAX)  [MENTION=290558]MONSTER[/MENTION]ID iNt  [MENTION=1134588]item[/MENTION]ID iNt  [MENTION=2178693]Dropr[/MENTION]atio ReaL,  [MENTION=313617]Drop[/MENTION]AmountMin INT,  [MENTION=313617]Drop[/MENTION]AmountMax INT
--------------------------------------------------------------------------
SET  [MENTION=614520]mob[/MENTION]            =    'MOB_SD_ANUBIS'/*Monster Code*/
SET  [MENTION=1134588]item[/MENTION]            =    ''/*Item Code*/
SET  [MENTION=313617]Drop[/MENTION]AmountMin    =    1 /*Drop Min*/
SET  [MENTION=313617]Drop[/MENTION]AmountMax    =    2 /*Drop Max*/
SET  [MENTION=2178693]Dropr[/MENTION]atio        =    0.5 /*0.5 = '50%' */
--------------------------------------------------------------------------
SET  [MENTION=290558]MONSTER[/MENTION]ID    =    (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 =  [MENTION=614520]mob[/MENTION])/**/
SET  [MENTION=1134588]item[/MENTION]ID        =    (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 Like  [MENTION=1134588]item[/MENTION])/**/
INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/
(RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3,RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName)/**/
VALUES  [MENTION=290558]MONSTER[/MENTION]ID  [MENTION=1134588]item[/MENTION]ID,0,0  [MENTION=313617]Drop[/MENTION]AmountMin  [MENTION=313617]Drop[/MENTION]AmountMax  [MENTION=2178693]Dropr[/MENTION]atio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/

For Example

ItemID = Select ID From RefobjCommon Where Codename128 Like '%ITEM_%'

The Query Works For Single Item's Perfect But With Like Statment it Give More Than 1 Value and it cause Error So Any Idea!?

[AceSpace]

https://pastebin.com/trrmUXXQ

That should work fine for multiple items

[Mc-Diesel]

Originally Posted by Locklyon

https://pastebin.com/trrmUXXQ

That should work fine for multiple items

Work Fine Thanks mate