Script problem....

[Appius4S]

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:

 Spoiler

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) 


EDIT:TENTERSERVER execute this script

[NightProfit]

Deleted

[Appius4S]

facepalm ... you read what i write ?

[iJirkusCZ]

Why you are doing it so hard? Just make INSERT INTO TITEMTABLE SELECT * FROM TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID

[Appius4S]

yeah i have do this ... now 2 min ago thx anyway after i finish i will post bypass here

[Syntaxfehler]

Script:

PHP Code:

ALTER PROCEDURE [dbo].[test]
@dwCharID        INT
AS
        INSERT INTO TGAME_GSP.dbo.TITEMTABLE SELECT * FROM TGAME_GSP.dbo.TITEMTABLE_BACKUP WHERE dwOwnerID = @dwCharID 


Edit:

Too late, I didn't refresh.

[Sicarium]

You can use the pointers as well.