ٍSQL Experts

06/26/2018 22:44 Mc-Diesel#1
Wanna Make This Query Added multiple Value To make it Easier to Add Full Degree As A Drop

HTML Code:
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!?
06/27/2018 00:36 AceSpace#2
Code:
https://pastebin.com/trrmUXXQ
That should work fine for multiple items
06/27/2018 01:08 Mc-Diesel#3
Quote:
Originally Posted by Locklyon View Post
Code:
https://pastebin.com/trrmUXXQ
That should work fine for multiple items
Work Fine Thanks mate :D