convert_after_mssql.sql 898 Bytes
DECLARE @IdBoxBase varchar(50)
DECLARE boxBase_cursor CURSOR FOR   
SELECT Id from Sungero_ExCore_BoxBase 

OPEN boxBase_cursor  
FETCH NEXT FROM boxBase_cursor INTO @IdBoxBase 

	WHILE @@FETCH_STATUS = 0  
	BEGIN  
	if exists (select 1 from Sungero_Docflow_Params where [Key] = 'LastBoxMessageId_' + @IdBoxBase) and
	   not exists (select 1 from Sungero_Docflow_Params where [Key] = 'LastBoxIncomingMessageId_' + @IdBoxBase)
		begin
		  declare @LastId varchar(250)
		  set @LastId = (select [Value] from Sungero_Docflow_Params where [Key] = 'LastBoxMessageId_' + @IdBoxBase)
		  insert into Sungero_Docflow_Params values ('LastBoxIncomingMessageId_' + @IdBoxBase, @LastId)
		  delete from Sungero_Docflow_Params where [Key] = 'LastBoxMessageId_' + @IdBoxBase
		end
	FETCH NEXT FROM boxBase_cursor INTO @IdBoxBase  
	END  

CLOSE boxBase_cursor  
DEALLOCATE boxBase_cursor