SELECT column_name FROM information_schema.columns WHERE table_name IN ('tbl_EAI_InboundFileProcessors') AND COLUMNPROPERTY(object_id(TABLE_SCHEMA+'.'+TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1 /* note: ignore dynamically generated identity columns; they have no meaning across different datasets */ SELECT column_name FROM information_schema.columns WITH (nolock) WHERE table_name = 'tbl_EAI_InboundFileProcessors' AND column_name NOT IN () SELECT #ValueList(qmd_processorColumns.column_name)# FROM tbl_EAI_InboundFileProcessors WITH (nolock) WHERE 1=1 AND rowId IN () 
/* *** SQL START *** */

	BEGIN TRANSACTION;
	
	DECLARE @rowId INT;
	

	/*COULD NOT FIND ANY FILE PROCESSOR TO EXPORT*/

	
	
	/* PROCESSOR: #qmd_processorRecord.fileFormat# (#qmd_processorRecord.ownerType##qmd_processorRecord.ownerId#) */
	SET @rowId = (SELECT rowId FROM tbl_EAI_InboundFileProcessors WHERE fileformat='#escapeSQLStr(qmd_processorRecord.fileformat)#' AND ownerType='#escapeSQLStr(qmd_processorRecord.ownerType)#' AND ownerId=#qmd_processorRecord.ownerId#);
		
		IF (@rowId IS NULL) BEGIN
			INSERT INTO tbl_EAI_InboundFileProcessors (
				#ValueList(qmd_processorColumns.column_name)#
			)
			VALUES (
					, '#escapeSQLStr(qmd_processorRecord[qmd_processorColumns.column_name])#'
			);
			SET @rowId = @@identity;
			PRINT 'INSERTED FILE FORMAT #qmd_processorRecord.fileFormat# (new processorId=' + CAST(@rowId as varchar(max)) + ', #qmd_processorRecord.ownerType##qmd_processorRecord.ownerId#)';
		END ELSE BEGIN
			UPDATE tbl_EAI_InboundFileProcessors SET
				
					,#qmd_processorColumns.column_name# = '#escapeSQLStr(qmd_processorRecord[qmd_processorColumns.column_name])#'
				
			WHERE rowId = @rowId;
			PRINT 'UPDATED FILE FORMAT #qmd_processorRecord.fileFormat# (new processorId=' + CAST(@rowId as varchar(max)) + ', #qmd_processorRecord.ownerType##qmd_processorRecord.ownerId#)';
		END
	
		
	
	
	
	COMMIT TRANSACTION;

/* *** SQL END *** */
#queryStringHTML#