Hi to all SQL pros out there.
I'm to create a stored procedure for tests and learning purposes only. The problem im having is if I execute [_ADD_ITEM_EXTERN], it only executes the first two instances and only gives me two items instead of 6.
My code:
I'm to create a stored procedure for tests and learning purposes only. The problem im having is if I execute [_ADD_ITEM_EXTERN], it only executes the first two instances and only gives me two items instead of 6.
My code:
PHP Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_YAWA] Script Date: 11/10/2021 10:04:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
-------------------------------------------------------------------------------------------------------------------
ALTER procedure [dbo].[_ANIMAL] [MENTION=3898309]charname[/MENTION]EQ varchar(64), [MENTION=395373]Chari[/MENTION]D int, [MENTION=954425]plus[/MENTION] int
AS
DECLARE [MENTION=748716]Degree[/MENTION] varchar(128), [MENTION=782085]chest[/MENTION] varchar(128), [MENTION=412764]legs[/MENTION] varchar(128), [MENTION=324753]arms[/MENTION] varchar(128), [MENTION=548095]coronet[/MENTION] varchar(128), [MENTION=915752]foot[/MENTION] varchar(128), [MENTION=4433738]Shoulder[/MENTION] varchar(128)
SET [MENTION=748716]Degree[/MENTION] = '02'
SET [MENTION=782085]chest[/MENTION] = 'ITEM_CH_M_HEAVY_' + [MENTION=748716]Degree[/MENTION] + '_BA_C_RARE'
SET [MENTION=412764]legs[/MENTION] = 'ITEM_CH_M_HEAVY_' + [MENTION=748716]Degree[/MENTION] + '_LA_C_RARE'
SET [MENTION=324753]arms[/MENTION] = 'ITEM_CH_M_HEAVY_' + [MENTION=748716]Degree[/MENTION] + '_AA_C_RARE'
SET [MENTION=548095]coronet[/MENTION] = 'ITEM_CH_M_HEAVY_' + [MENTION=748716]Degree[/MENTION] + '_CA_C_RARE'
SET [MENTION=915752]foot[/MENTION] = 'ITEM_CH_M_HEAVY_' + [MENTION=748716]Degree[/MENTION] + '_FA_C_RARE'
SET [MENTION=4433738]Shoulder[/MENTION] = 'ITEM_CH_M_HEAVY_' + [MENTION=748716]Degree[/MENTION] + '_SA_C_RARE'
BEGIN EXEC SRO_VT_SHARD.[dbo].[_ADD_ITEM_EXTERN] [MENTION=3898309]charname[/MENTION]EQ, [MENTION=782085]chest[/MENTION], 1, [MENTION=954425]plus[/MENTION] END
BEGIN EXEC SRO_VT_SHARD.[dbo].[_ADD_ITEM_EXTERN] [MENTION=3898309]charname[/MENTION]EQ, [MENTION=412764]legs[/MENTION], 1, [MENTION=954425]plus[/MENTION] END
BEGIN EXECUTE [MENTION=1593521]Results[/MENTION]RO_VT_SHARD.[dbo].[_ADD_ITEM_EXTERN] [MENTION=3898309]charname[/MENTION]EQ, [MENTION=324753]arms[/MENTION], 1, [MENTION=954425]plus[/MENTION] END
BEGIN EXECUTE SRO_VT_SHARD.[dbo].[_ADD_ITEM_EXTERN] [MENTION=3898309]charname[/MENTION]EQ, [MENTION=548095]coronet[/MENTION], 1, [MENTION=954425]plus[/MENTION] END
EXECUTE SRO_VT_SHARD.[dbo].[_ADD_ITEM_EXTERN] [MENTION=3898309]charname[/MENTION]EQ, [MENTION=915752]foot[/MENTION], 1, [MENTION=954425]plus[/MENTION]
EXECUTE SRO_VT_SHARD.[dbo].[_ADD_ITEM_EXTERN] [MENTION=3898309]charname[/MENTION]EQ, [MENTION=4433738]Shoulder[/MENTION], 1, [MENTION=954425]plus[/MENTION]
EXECUTE [SRO_RJ_SHA].[dbo].[_FN_ADD_INITIAL_EQUIP] [MENTION=395373]Chari[/MENTION]D, 5, 4448, 55
