Help with SQL Stored Procedure

rieljames · 10/11/2021, 21:49

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:

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

Ryotic · 10/12/2021, 01:10

Quote:

Originally Posted by rieljames

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:

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

Sro_RJ_SHA?

OKeks · 10/12/2021, 21:21

It is very hard to read your code, why don't you add a txt file?

If the first two items out of 6 are working, please copy paste the first two "exec" lines two times more and change the 4 lines you get to the other 4 items. 1 and 2 look similar and are working
3 and 4 look similar and are not working
5 and 6 look similar and are not working