CREATE PROCEDURE dbo.lion_UpdateTasksNewOrder(  @Table TasksNewOrderTableType READONLY )
AS

BEGIN
	  	
    SELECT * INTO #t3 FROM @Table

    CREATE NONCLUSTERED INDEX IDX_T3_UID_TASK ON #t3(UUID_TASK)
    CREATE NONCLUSTERED INDEX IDX_T3_UID_USER ON #t3(UUID_USER)
      	      	        	        			
    UPDATE dbo.lion_Tasks
    SET     

    order_new =  #t3.ORDER_NEW,   
    __usn_field_order_new = #t3.USN_ORDER_NEW
   
    FROM #t3
    WHERE dbo.lion_Tasks.uid_obj = #t3.UUID_TASK
    
	   				
    UPDATE dbo.lion_Tasks_Changes_Parts
    SET 
	
    __usn_entity_cp = #t3.USN_ENTITY

    FROM  #t3
    WHERE dbo.lion_Tasks_Changes_Parts.uid_task_cp = #t3.UUID_TASK AND dbo.lion_Tasks_Changes_Parts.uid_user_cp = #t3.UUID_USER
   			   			 
 
END
GO

CREATE PROCEDURE dbo.lion_UpdateTasksNewOrder(  @Table TasksNewOrderTableType READONLY )
AS

BEGIN
	  	
    UPDATE TasksTable
    SET     

    order_new = t.ORDER_NEW,   
    __usn_field_order_new = t.USN_ORDER_NEW
   
    FROM dbo.lion_Tasks TasksTable
    INNER JOIN @Table t
    ON t.UUID_TASK = TasksTable.uid_obj
    
    UPDATE TasksTableCP
    SET 
	
    __usn_entity_cp = tcp.USN_ENTITY

    FROM dbo.lion_Tasks_Changes_Parts TasksTableCP
    INNER JOIN @Table tcp
    ON tcp.UUID_TASK = TasksTableCP.uid_task_cp AND tcp.UUID_USER = TasksTableCP.uid_user_cp
   			   			     
END
GO