use lime_dev
go
		--Declare all ids here!
		DECLARE @documentid int

		DECLARE partCur CURSOR LOCAL STATIC READ_ONLY FORWARD_ONLY FOR
			SELECT iddocument
			FROM [document]
			WHERE [document].[status] = 0 AND [createdtime] > '2018-10-23 13:00'

		OPEN partCur
			FETCH NEXT FROM partCur INTO @documentid
			WHILE @@FETCH_STATUS = 0
			BEGIN
				EXEC [dbo].[lsp_removerecord] @@idtable = 1601, @@table = 'document', @@idrecord = @documentid, @@descriptive = null, @@iduser = 1, @@key = '', @@transactionid = null
				, @@sessionidentifier = '', @@username = 'admin', @@verifyrelations = 1, @@debug = 0
				FETCH NEXT FROM partCur INTO @documentid
			END
			CLOSE partCur
			DEALLOCATE partCur

---------------------------
use lime_dev
go
		--Declare all ids here!
		DECLARE @historyid int

		DECLARE partCur CURSOR LOCAL STATIC READ_ONLY FORWARD_ONLY FOR
			SELECT idhistory
			FROM [history]
			WHERE [history].[status] = 0 AND [createdtime] > '2018-10-23 13:00'

		OPEN partCur
			FETCH NEXT FROM partCur INTO @historyid
			WHILE @@FETCH_STATUS = 0
			BEGIN
				EXEC [dbo].[lsp_removerecord] @@idtable = 3001, @@table = 'history', @@idrecord = @historyid, @@descriptive = null, @@iduser = 1, @@key = '', @@transactionid = null
				, @@sessionidentifier = '', @@username = 'admin', @@verifyrelations = 1, @@debug = 0
				FETCH NEXT FROM partCur INTO @historyid
			END
			CLOSE partCur
			DEALLOCATE partCur

---------------------------
use lime_dev
go
		--Declare all ids here!
		DECLARE @personid int

		DECLARE partCur CURSOR LOCAL STATIC READ_ONLY FORWARD_ONLY FOR
			SELECT idperson
			FROM [person]
			WHERE [person].[status] = 0 AND [timestamp] > '2018-10-23 13:00'

		OPEN partCur
			FETCH NEXT FROM partCur INTO @personid
			WHILE @@FETCH_STATUS = 0
			BEGIN
				EXEC [dbo].[lsp_removerecord] @@idtable = 1801, @@table = 'person', @@idrecord = @personid, @@descriptive = null, @@iduser = 1, @@key = '', @@transactionid = null
				, @@sessionidentifier = '', @@username = 'admin', @@verifyrelations = 1, @@debug = 0
				FETCH NEXT FROM partCur INTO @personid
			END
			CLOSE partCur
			DEALLOCATE partCur

---------------------------

use lime_dev
go
		--Declare all ids here!
		DECLARE @companyid int

		DECLARE partCur CURSOR LOCAL STATIC READ_ONLY FORWARD_ONLY FOR
			SELECT idcompany
			FROM [company]
			WHERE [company].[status] = 0 AND [createdtime] > '2018-10-23 13:00'

		OPEN partCur
			FETCH NEXT FROM partCur INTO @companyid
			WHILE @@FETCH_STATUS = 0
			BEGIN
				EXEC [dbo].[lsp_removerecord] @@idtable = 1501, @@table = 'company', @@idrecord = @companyid, @@descriptive = null, @@iduser = 1, @@key = '', @@transactionid = null
				, @@sessionidentifier = '', @@username = 'admin', @@verifyrelations = 1, @@debug = 0
				FETCH NEXT FROM partCur INTO @companyid
			END
			CLOSE partCur
			DEALLOCATE partCur