Using CURSOR in SQL

Declare @AppId as varchar(50)

Declare @InvoiceNo as varchar(50)

declare @DueDate as datetime

DECLARE AppCURS CURSOR FOR

select cit_applicationno,new_InvoiceNo,cit_DueDate from ZmZm_MSCRM.dbo.cit_application where statuscode=912660015

OPEN AppCURS

fetch next from AppCURS into @AppId,@InvoiceNo,@DueDate

WHILE @@FETCH_STATUS = 0

BEGIN  

update AX2012R2_DB.dbo.PURCHTABLE 

set 

CRMINVIOCENUM=@InvoiceNo,

ACCOUNTINGDATE=@DueDate,

ISINVOICERECEIVED=1

where VENDORREF=@AppId

fetch next from AppCURS into @AppId,@InvoiceNo,@DueDate

END   

CLOSE AppCURS   

DEALLOCATE AppCURS