Hello guys ... i want to insert all values from TITEMTABLE_BACKUP in TITEMTABLE but if i set "SELECT TOP 1" the function inserted in the table the first object what corresponding with(dwOwnerID) .. I want to insert my all objects that correspond with dwOwnerID, if I delete (TOP 1) receive the following error : 21000 - [SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
i hope you can help me , thx
Here is script:
EDIT:TENTERSERVER execute this script
i hope you can help me , thx
Here is script:
PHP Code:
ALTER PROCEDURE [dbo].[test]
@dwCharID INT
AS
DECLARE @dlID BIGINT
DECLARE @bStorageType TINYINT
DECLARE @dwStorageID INT
DECLARE @bOwnerType TINYINT
DECLARE @dwOwnerID INT
DECLARE @bItemID TINYINT
DECLARE @wItemID SMALLINT
DECLARE @bLevel TINYINT
DECLARE @bCount TINYINT
DECLARE @bGLevel TINYINT
DECLARE @dwDuraMax INT
DECLARE @dwDuraCur INT
DECLARE @bRefineCur TINYINT
DECLARE @dEndTime SMALLDATETIME
DECLARE @bGradeEffect TINYINT
DECLARE @bMagic1 TINYINT
DECLARE @bMagic2 TINYINT
DECLARE @bMagic3 TINYINT
DECLARE @bMagic4 TINYINT
DECLARE @bMagic5 TINYINT
DECLARE @bMagic6 TINYINT
DECLARE @wValue1 SMALLINT
DECLARE @wValue2 SMALLINT
DECLARE @wValue3 SMALLINT
DECLARE @wValue4 SMALLINT
DECLARE @wValue5 SMALLINT
DECLARE @wValue6 SMALLINT
DECLARE @dwTime1 INT
DECLARE @dwTime2 INT
DECLARE @dwTime3 INT
DECLARE @dwTime4 INT
DECLARE @dwTime5 INT
DECLARE @dwTime6 INT
SET @dlID = (SELECT TOP 1 dlID FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bStorageType = (SELECT TOP 1 bStorageType FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwStorageID = (SELECT TOP 1 dwStorageID FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bOwnerType = (SELECT TOP 1 bOwnerType FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwOwnerID = (SELECT TOP 1 dwOwnerID FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bItemID = (SELECT TOP 1 bItemID FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @wItemID = (SELECT TOP 1 wItemID FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bLevel = (SELECT TOP 1 bLevel FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bCount = (SELECT TOP 1 bCount FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bGLevel = (SELECT TOP 1 bGLevel FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwDuraMax = (SELECT TOP 1 dwDuraMax FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwDuraCur = (SELECT TOP 1 dwDuraCur FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bRefineCur = (SELECT TOP 1 bRefineCur FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dEndTime = (SELECT TOP 1 dEndTime FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bGradeEffect = (SELECT TOP 1 bGradeEffect FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bMagic1 = (SELECT TOP 1 bMagic1 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bMagic2 = (SELECT TOP 1 bMagic2 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bMagic3 = (SELECT TOP 1 bMagic3 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bMagic4 = (SELECT TOP 1 bMagic4 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bMagic5 = (SELECT TOP 1 bMagic5 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @bMagic6 = (SELECT TOP 1 bMagic6 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @wValue1 = (SELECT TOP 1 wValue1 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @wValue2 = (SELECT TOP 1 wValue2 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @wValue3 = (SELECT TOP 1 wValue3 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @wValue4 = (SELECT TOP 1 wValue4 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @wValue5 = (SELECT TOP 1 wValue5 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @wValue6 = (SELECT TOP 1 wValue6 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwTime1 = (SELECT TOP 1 dwTime1 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwTime2 = (SELECT TOP 1 dwTime2 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwTime3 = (SELECT TOP 1 dwTime3 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwTime4 = (SELECT TOP 1 dwTime4 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwTime5 = (SELECT TOP 1 dwTime5 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
SET @dwTime6 = (SELECT TOP 1 dwTime6 FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID)
INSERT INTO TITEMTABLE(dlID,bStorageType,dwStorageID,bOwnerType,dwOwnerID,bItemID,wItemID,bLevel,bCount,bGLevel,dwDuraMax,dwDuraCur,bRefineCur,dEndTime,bGradeEffect,bMagic1,bMagic2,bMagic3,bMagic4,bMagic5,bMagic6,wValue1,wValue2,wValue3,wValue4,wValue5,wValue6,dwTime1,dwTime2,dwTime3,dwTime4,dwTime5,dwTime6) VALUES(@dlID,@bStorageType,@dwStorageID,@bOwnerType,@dwOwnerID,@bItemID,@wItemID,@bLevel,@bCount,@bGLevel,@dwDuraMax,@dwDuraCur,@bRefineCur,@dEndTime,@bGradeEffect,@bMagic1,@bMagic2,@bMagic3,@bMagic4,@bMagic5,@bMagic6,@wValue1,@wValue2,@wValue3,@wValue4,@wValue5,@wValue6,@dwTime1,@dwTime2,@dwTime3,@dwTime4,@dwTime5,@dwTime6)