IF OBJECT_ID('tempdb..#qatable') IS NOT NULL DROP TABLE #qatable
            
            SELECT ---distinct  
            welQA.SourceWorkLog_WorkID WorkID,QAresult, ql.ID,qtc.PLC_ID QATrigger, ql.ResultSetWhen -- добавил в выборку поле с ДатойВременем 
            INTO #qatable           
              FROM QualityLog ql

DECLARE
                 @WorkID bigint
                ,@QAresult            NVARCHAR(max)
                ,@qaId                int
                ,@QATrigger              int
                ,@QAResultSetWhen     datetime --добавил локальную переменную
                DECLARE qa_cursor CURSOR FOR
                SELECT
                qt.WorkID
                    ,qt.QAresult
                    ,qt.ID
                    ,qt.QATrigger
                    ,qt.ResultSetWhen --добавил поле во временную таблицу
                FROM #qatable qt

                OPEN qa_cursor
                FETCH NEXT FROM qa_cursor
                INTO
                 @WorkID                 
                ,@QAresult        
                ,@qaId      
                ,@QATrigger      
                ,@QAResultSetWhen -- заполнил курсором поле
                WHILE @@FETCH_STATUS=0
                BEGIN
                    INSERT INTO x_1C_Buffer_MaterialReleaseQAResults (
                    QAResult,WorkID,QATrigger,QAResultSetWhen)                                         -- вставил в поле
                    VALUES (@QAresult,@WorkID,@QATrigger,@QAResultSetWhen    )      -- значение
            
                    DECLARE @m int = scope_identity()
                    INSERT INTO [x_1C_Buffer_MaterialReleaseQAResults_Cross] (QAResult_ID,QualityLogId)
                    values(@m,@qaId)           
                FETCH NEXT FROM qa_cursor
                INTO
                @WorkID
                ,@QAresult        
                ,@qaId
                ,@QATrigger    
                ,@QAResultSetWhen                 --продолжил читать
                END
                CLOSE qa_cursor
                DEALLOCATE qa_cursor             
            COMMIT

SELECT welQA.SourceWorkLog_WorkID WorkID, ql.ID,qtc.PLC_ID QATrigger, ql.ResultSetWhen
			FROM QualityLog ql, WorkEventLog welQA, QualityTrigCondition qtc

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[x_1C_QAResult]
AS
BEGIN
	BEGIN TRY
	    BEGIN TRANSACTION
IF OBJECT_ID('tempdb..#qatable') IS NOT NULL DROP TABLE #qatable
			
            SELECT ---distinct  
			welQA.SourceWorkLog_WorkID WorkID,QAresult, ql.ID,qtc.PLC_ID QATrigger, ql.ResultSetWhen
			INTO #qatable           
              FROM QualityLog ql
              JOIN WorkEventLog welQA on ql.ShipmentEventLog_ID is  null and ql.WorkEventLog_ID =welQA.ID  
			  JOIN QualityTrigCondition qtc ON qtc.ID=ql.QualityTrigCondition_ID
              CROSS APPLY( 
              SELECT 
            [dbo].[fnConcateTable]((
            SELECT distinct
            -- ISNULL(CAST(ml.PLC_ID                  AS NVARCHAR),'N/A') col
            --,ISNULL(CAST(welQA.SourceWorkLog_WorkID AS NVARCHAR),'N/A') col
            --,ISNULL(CAST(e.PLC_ID                   AS NVARCHAR),'N/A') col ,
            ISNULL(CAST(stpn.ID                    AS NVARCHAR),'N/A') col
            ,ISNULL(CAST(qpl.SampleParameter_Value  AS NVARCHAR),'N/A') col 
			FROM EquipmentLog el        
             LEFT JOIN Equipment e                ON e.Name =el.Equipment_Name and welQA.EquipmentLog_ID =el.ID
             JOIN WorkEventLog welProd            ON welProd.SourceWorkLog_WorkID =welQA.SourceWorkLog_WorkID and welProd.PhaseType_Description not like '%transfer%'
             JOIN ProductionLog pl                ON pl.WorkEventLog_ID = welProd.ID
             JOIN MaterialLog ml                  ON ml.ID = pl.MaterialLog_ID
             LEFT JOIN QualityParameterLog qpl    ON qpl.QualityLog_ID = ql.ID
             JOIN x_SampleTypeParameterNames stpn ON stpn.Name = qpl.SampleParameter_Name
              WHERE qpl.SampleParameter_Value is not null
              FOR XML RAW('tab'), ELEMENTS),'=',';') AS QAresult)s
              WHERE QAresult is not null 			 
			  AND ql.id =    (SELECT max(id) FROM QualityLog ql2 WHERE ql2.WorkEventLog_ID = ql.WorkEventLog_ID and ql2.SampleType_Description=ql.SampleType_Description and ql.QualityResult_Description=N'Approved')
			  and not exists (SELECT * FROM x_1C_Buffer_MaterialReleaseQAResults_Cross qarc WHERE qarc.[QualityLogId] = ql.ID)
				DECLARE 
			     @WorkID bigint
				,@QAresult            NVARCHAR(max)
				,@qaId                int
				,@QATrigger			  int
				,@QAResultSetWhen     datetime
				DECLARE qa_cursor CURSOR FOR
				SELECT
				qt.WorkID
					,qt.QAresult
					,qt.ID
					,qt.QATrigger
					,qt.ResultSetWhen
				FROM #qatable qt

				OPEN qa_cursor
				FETCH NEXT FROM qa_cursor
				INTO
				 @WorkID 				
				,@QAresult        
				,@qaId      
				,@QATrigger	  
				,@QAResultSetWhen 
				WHILE @@FETCH_STATUS=0
				BEGIN
					INSERT INTO x_1C_Buffer_MaterialReleaseQAResults (
					QAResult,WorkID,QATrigger,QAResultSetWhen
					) VALUES (@QAresult,@qaId ,@QATrigger,@QAResultSetWhen	)
			
			        DECLARE @m int = scope_identity()
			        INSERT INTO [x_1C_Buffer_MaterialReleaseQAResults_Cross] (QAResult_ID,QualityLogId)
			        values(@m,@qaId)
			
				FETCH NEXT FROM qa_cursor
				INTO 
				@WorkID 
				,@QAresult        
				,@qaId
				,@QATrigger	
				,@QAResultSetWhen
				END
				CLOSE qa_cursor

				DEALLOCATE qa_cursor 			
			COMMIT
	END TRY
	BEGIN CATCH
	 ROLLBACK TRANSACTION
		DECLARE @ErrorMessage NVARCHAR(255);
		SET @ErrorMessage = ERROR_MESSAGE();
		INSERT INTO errorlog (ErrorValue, ErrorMessage,ErrorTime, ObjectName, UserName)
		VALUES (680000,@ErrorMessage,GETDATE(),'x_1C_QAResult','DataCollection')
	END CATCH
END

		

SELECT 
      ,[QAResult]
      ,[WorkID]
      ,[QATrigger]
      ,[QAResultSetWhen]
  FROM x_1C_Buffer_MaterialReleaseQAResults
  WHERE QAResultSetWhen is not null