CREATE PROCEDURE dbo.GMWBWImportScript AS

declare @gmnv varchar(20)
declare @recid varchar(15)
declare @ACCOUNTNO varchar(20)
declare @itemcode varchar(35)
declare @INFO varchar(255)
declare @Desc1 varchar(20)
declare @invoicedate varchar(10)
declare @supplierID varchar(20)
declare @unitPrice varchar(10)
declare @Shipqty varchar(6)
declare @totalsaleamt varchar(20)
declare @invoicelineuid varchar(40)
declare @desc2 varchar(40)
declare @city varchar(30)
set nocount on

DECLARE bclwbw2 CURSOR
FOR select accountno, invoice_line_uid, item_id, INFO,  [Item Desc], invoice_date, supplier_name, unit_price, qty_shipped, extended_price, [desc 2], city from bclgmItemDetailImport 

OPEN bclwbw2

FETCH NEXT FROM bclwbw2 INTO @ACCOUNTNO, @invoicelineuid, @itemcode , @INFO, @Desc1, @invoicedate, @supplierID, @unitprice, @Shipqty, @totalsaleamt, @desc2, @city

WHILE @@fetch_status = 0
begin

EXEC GMW_NV_Create @gmnv OUTPUT
EXEC GMW_NV_SetValue @gmnv, 'user', 'MASTER'
EXEC GMW_NV_SetValue @gmnv, 'AccountNo', @ACCOUNTNO
EXEC GMW_NV_SetValue @gmnv, 'detail', 'Item Sold'
EXEC GMW_NV_SetValue @gmnv, 'ref', @itemcode
EXEC GMW_NV_SetValue @gmnv, 'notes', @INFO
EXEC GMW_NV_SetValue @gmnv, 'ufield1', @Desc1
EXEC GMW_NV_SetValue @gmnv, 'ufield2', @invoicedate
EXEC GMW_NV_SetValue @gmnv, 'ufield3', @supplierID
EXEC GMW_NV_SetValue @gmnv, 'ufield4', @unitPrice
EXEC GMW_NV_SetValue @gmnv, 'ufield5', @Shipqty
EXEC GMW_NV_SetValue @gmnv, 'ufield6', @totalsaleamt
EXEC GMW_NV_SetValue @gmnv, 'ufield7', @invoicelineuid
EXEC GMW_NV_SetValue @gmnv, 'ufield8', @desc2
EXEC GMW_NV_SetValue @gmnv, 'ufield9', @city
EXEC GMW_WriteDetail1 @gmnv
EXEC GMW_NV_GetValue @gmnv, 'recid', @recid OUTPUT

FETCH NEXT FROM bclwbw2 INTO @ACCOUNTNO, @invoicelineuid, @itemcode , @INFO, @Desc1, @invoicedate, @supplierID, @unitprice, @Shipqty, @totalsaleamt, @desc2, @city
end

DEALLOCATE bclwbw2

EXEC GMW_NV_Delete @gmnv
GO

Transaction (Process ID 65) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205).  The step failed.

Line 1: Incorrect syntax near 'DO'. [SQLSTATE 42000] (Error 170)  Associated statement is not prepared [SQLSTATE HY007] (Error 0).  The step failed.

Line 1: Incorrect syntax near 'DO'. [SQLSTATE 42000] (Error 170)  Associated statement is not prepared [SQLSTATE HY007] (Error 0)  Line 1: Incorrect syntax near 'DO'. [SQLSTATE 42000] (Error 170).  The step failed.

Line 1: Incorrect syntax near 'DO'. [SQLSTATE 42000] (Error 170)  Associated statement is not prepared [SQLSTATE HY007] (Error 0)  Transaction (Process ID 70) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205).  The step failed.