Malzeme kartlarına Muhasebe hesap kodları ekleme

[ahmeyasin]

merhaba, Malzeme kartlarına Muhasebe hesap kodu ekletmek için aşağıdaki sorguyu yapıyorum ama bir yerde hata alıyorum, yardımcı olacak arkadaşlara şimdiden teşekkür ediyorum.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
DECLARE @newRef AS INT
DECLARE @nmusRef AS INT
DECLARE @stREF AS INT
DECLARE @Lref AS INT
DECLARE @TIPP AS INT
DECLARE @HSKOD AS INT

DECLARE MUST_CUR CURSOR FOR

SELECT LOGICALREF FROM LG_063_ITEMS
OPEN MUST_CUR;

@TIPP=1 //* ALIM KODLARI ICIN 1 , SATIS KODLARI ICIN 3 *//
@HSKOD=852 //* Hesap kodu Referans *//

FETCH NEXT FROM MUST_CUR INTO @nmusRef
WHILE @@FETCH_STATUS = 0
BEGIN

SET @newRef =(SELECT ISNULL(MAX(LOGICALREF),0) FROM LG_063_CRDACREF)+1
INSERT INTO LG_063_CRDACREF (LOGICALREF,TRCODE,CARDREF,TYP, ACCOUNTREF,CENTERREF,SITEID,RECSTATUS,ORGLOGICREF,PROJECTREF)
VALUES (@newRef,1,@nmusRef,@TIPP,@HSKOD,0,0,0,0,0)
FETCH NEXT FROM MUST_CUR INTO @nmusRef
END;
CLOSE MUST_CUR;
DEALLOCATE MUST_CUR;
GO

[Vedat ÖZER]

Merhaba

ınsert eklerken LOGICALREF alanını göndermenize gerek yok sql server kendisi otamatik numara verir yok ben illa numara verecem diyorsanız


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
DECLARE @newRef AS INT
DECLARE @nmusRef AS INT
DECLARE @stREF AS INT
DECLARE @Lref AS INT
DECLARE @TIPP AS INT
DECLARE @HSKOD AS INT

DECLARE MUST_CUR CURSOR FOR

SELECT LOGICALREF FROM LG_063_ITEMS
OPEN MUST_CUR;

@TIPP=1 //* ALIM KODLARI ICIN 1 , SATIS KODLARI ICIN 3 *//
@HSKOD=852 //* Hesap kodu Referans *//

FETCH NEXT FROM MUST_CUR INTO @nmusRef
WHILE @@FETCH_STATUS = 0
BEGIN

SET IDENTITY_INSERT LG_063_CRDACREF ON;
SET @newRef =(SELECT ISNULL(MAX(LOGICALREF),0) FROM LG_063_CRDACREF)+1
INSERT INTO LG_063_CRDACREF (LOGICALREF,TRCODE,CARDREF,TYP, ACCOUNTREF,CENTERREF,SITEID,RECSTATUS,ORGLOGICREF,PROJECTREF)
VALUES (@newRef,1,@nmusRef,@TIPP,@HSKOD,0,0,0,0,0)
SET IDENTITY_INSERT LG_063_CRDACREF OFF;

FETCH NEXT FROM MUST_CUR INTO @nmusRef
END;
CLOSE MUST_CUR;
DEALLOCATE MUST_CUR;
GO
Başa dön