Script para remover processo Nfse

Introdução

Qual comando para excluir processo Nfse - Limpeza Base?

Passo a passo

Segue script para exclusão processo Nfse. declare @rpsNumber bigint, @rpsKind tinyint, @rpsSeries varchar(5), @jobId bigint

set @rpsNumber = 8 – Número da RPS set @rpsKind = 1 – Tipo da RPS set @rpsSeries = 'NDD' – Série da RPS set @jobId = 12 – ID do Job

declare @documentId bigint

set @documentId = (select id from tbDocumentNFSe doc where doc.docKind = @rpsKind and doc.docNumber = @rpsNumber and doc.docSeries = @rpsSeries and doc.jobId = @jobId)

declare _procId cursor for

            select processId from tbProcessDocument where documentId = @documentId

            declare @procId bigint

            open _procId

            fetch next from _procId into @procId

            while @@fetch_status = 0
                           begin
                                           delete from tbProcessDocument where processId = @procId
                                           delete from tbProcessDataNFSe where processId = @procId
                                           delete from tbInProcessNFSe where processId = @procId
                                           delete from tbProcessNFSe where id = @procId

                                           fetch next from _procId into @procId
                           end

            close _procId

deallocate _procId

delete from tbDocumentMessageNFSe where documentId = @documentId delete from tbDocumentNFSe where id = @documentId delete from tbNFSeSefaz where rpsNumber = @rpsNumber and rpsSeries = @rpsSeries and rpsKind = @rpsKind and jobId = @jobId

Vale salientar que qualquer processo via banco de dados e responsabilidade do usuário.

Outras informações

Fonte: Paulo Roberto Almeida