-- GoatCheezCREATE PROCEDURE GET_ITEM_NAME@strRet char(50) OUTPUT, @itemID int, ASDECLARE @BaseID int, @ExtTbl tinyint, @ExtId smallint, @Row int SET @ExtTbl = 0 SET @ExtId = 0 SET @Row = 0 SET @BaseID = CAST((SUBSTRING(CAST(@itemID AS varchar(9)),1,6) + '000') AS int) SET @ExtId = CAST(SUBSTRING(CAST(@itemID AS varchar(9)),6,3) AS smallint) SELECT @Row = COUNT(*) FROM ITEM_BASIC WHERE dwID = @BaseID IF @Row = 0 BEGIN SET @strRet = 'Invalid Item' RETURN END SELECT @ExtTbl = byExtIndex FROM ITEM_BASIC WHERE dwID = @BaseID IF ExtId <= 10 BEGIN IF ExtId > 0 BEGIN SET @strRet = (SELECT szName FROM ITEM_BASIC WHERE dwID = @BaseID) + ' +' + CAST(@ExtId AS varchar(1)) RETURN END ELSE BEGIN SET @strRet = (SELECT szName FROM ITEM_BASIC WHERE dwID = @BaseID) RETURN END END IF ExtId <= 250 BEGIN IF ExtId < 100 BEGIN SET @strRet = 'Special' + (SELECT szName FROM ITEM_BASIC WHERE dwID = @BaseID) + ' +' + SUBSTRING(CAST(@ExtId AS varchar(2)),2,1) RETURN END ELSE BEGIN SET @strRet = 'Special' + (SELECT szName FROM ITEM_BASIC WHERE dwID = @BaseID) + ' +' + SUBSTRING(CAST(@ExtId AS varchar(3)),3,1) RETURN END END IF ExtId = 1 BEGIN SELECT @strRet = szHeader FROM ITEMEXT1 WHERE dwID = @ExtId RETURN END IF ExtId = 2 BEGIN SELECT @strRet = szHeader FROM ITEMEXT2 WHERE dwID = @ExtId RETURN END IF ExtId = 3 BEGIN SELECT @strRet = szHeader FROM ITEMEXT3 WHERE dwID = @ExtId RETURN END IF ExtId = 4 BEGIN SELECT @strRet = szHeader FROM ITEMEXT4 WHERE dwID = @ExtId RETURN END IF ExtId = 5 BEGIN SELECT @strRet = szHeader FROM ITEMEXT5 WHERE dwID = @ExtId RETURN END IF ExtId = 6 BEGIN SELECT @strRet = szHeader FROM ITEMEXT6 WHERE dwID = @ExtId RETURN END IF ExtId = 7 BEGIN SELECT @strRet = szHeader FROM ITEMEXT7 WHERE dwID = @ExtId RETURN END IF ExtId = 8 BEGIN SELECT @strRet = szHeader FROM ITEMEXT8 WHERE dwID = @ExtId RETURN END IF ExtId = 9 BEGIN SELECT @strRet = szHeader FROM ITEMEXT9 WHERE dwID = @ExtId RETURN END IF ExtId = 10 BEGIN SELECT @strRet = szHeader FROM ITEMEXT10 WHERE dwID = @ExtId RETURN END IF ExtId = 11 BEGIN SELECT @strRet = szHeader FROM ITEMEXT11 WHERE dwID = @ExtId RETURN END IF ExtId = 12 BEGIN SELECT @strRet = szHeader FROM ITEMEXT12 WHERE dwID = @ExtId RETURN END IF ExtId = 13 BEGIN SELECT @strRet = szHeader FROM ITEMEXT13 WHERE dwID = @ExtId RETURN END IF ExtId = 14 BEGIN SELECT @strRet = szHeader FROM ITEMEXT14 WHERE dwID = @ExtId RETURN END IF ExtId = 15 BEGIN SELECT @strRet = szHeader FROM ITEMEXT15 WHERE dwID = @ExtId RETURN END IF ExtId = 16 BEGIN SELECT @strRet = szHeader FROM ITEMEXT16 WHERE dwID = @ExtId RETURN END IF ExtId = 17 BEGIN SELECT @strRet = szHeader FROM ITEMEXT17 WHERE dwID = @ExtId RETURN END IF ExtId = 18 BEGIN SELECT @strRet = szHeader FROM ITEMEXT18 WHERE dwID = @ExtId RETURN END IF ExtId = 19 BEGIN SELECT @strRet = szHeader FROM ITEMEXT19 WHERE dwID = @ExtId RETURN END IF ExtId = 20 BEGIN SELECT @strRet = szHeader FROM ITEMEXT20 WHERE dwID = @ExtId RETURN END IF ExtId = 21 BEGIN SELECT @strRet = szHeader FROM ITEMEXT21 WHERE dwID = @ExtId RETURN END IF ExtId = 22 BEGIN SELECT @strRet = szHeader FROM ITEMEXT22 WHERE dwID = @ExtId RETURN END IF ExtId = 23 BEGIN SELECT @strRet = szHeader FROM ITEMEXT23 WHERE dwID = @ExtId RETURN ENDGO