alter PROCEDURE [dbo].[DeliveryDocumentsCreateDetailsFormEntranceGoods] @EntranceGoodsIds SelectedId READONLY, @DeliveryDocumentId UNIQUEIDENTIFIER AS BEGIN DECLARE @EntraceGoodsId UNIQUEIDENTIFIER DECLARE cEGId CURSOR FAST_FORWARD READ_ONLY FOR SELECT id FROM @EntranceGoodsIds S Open cEGId FETCH NEXT FROM cEGId INTO @EntraceGoodsId WHILE (@@FETCH_STATUS = 0) BEGIN DECLARE @WorkOrderId uniqueidentifier DECLARE @EGNotes varchar(1000) SELECT @EGNotes = Notes, @WorkOrderId = WorkOrderId FROM EntranceGoods WHERE EntranceGoodsId = @EntraceGoodsId IF @WorkOrderId IS NOT NULL UPDATE DeliveryDocuments SET WorkOrderId = @WorkOrderId, Notes = @EGNotes WHERE DeliveryDocumentId = @DeliveryDocumentId DECLARE @EGDeliveryDocumentId uniqueidentifier = (SELECT DeliveryDocumentId FROM EntranceGoods WHERE EntranceGoodsId = @EntraceGoodsId) DECLARE @MaxRowId INT SET @MaxRowId = ISNULL((SELECT MAX(RowId) FROM DeliveryDocumentDetails WHERE DeliveryDocumentId = @DeliveryDocumentId), 0) IF @EGDeliveryDocumentId IS NOT NULL BEGIN --ENTRANCEGOOD FROM DDT INSERT INTO DeliveryDocumentDetails( StyleId, Quantity, WorkRevealedQuantity, RevealedQuantity, DeliveryDocumentId, DeliveryDocumentDetailsId, RowId) SELECT StyleId as StyleId, RevealedQuantity as Quantity, NULL as WorkRevealedQuantity, RevealedQuantity as RevealedQuantity, @DeliveryDocumentId as DeliveryDocumentId, NEWID() as DeliveryDocumentDetailsId, @MaxRowId + RowId as RowId FROM DeliveryDocumentDetails WHERE DeliveryDocumentId = @EGDeliveryDocumentId END ELSE BEGIN --ENTRANCEGOOD FROM OrderDetails INSERT INTO DeliveryDocumentDetails( StyleId, Quantity, WorkRevealedQuantity, RevealedQuantity, DeliveryDocumentId, DeliveryDocumentDetailsId, RowId) SELECT StyleId as StyleId, RevealedQuantity as Quantity, NULL as WorkRevealedQuantity, RevealedQuantity as RevealedQuantity, @DeliveryDocumentId as DeliveryDocumentId, NEWID() as DeliveryDocumentDetailsId, @MaxRowId + RowNumber as RowId FROM EntranceGoodsOrderDetails WHERE EntranceGoodsId = @EntraceGoodsId END FETCH NEXT FROM cEGId INTO @EntraceGoodsId END CLOSE cEGId DEALLOCATE cEGId END