select o.id, dbo.DateToDateStr( o.CREATIONDATETIME), vg.id, vg.* from orders o
left join VG_FIELD_VALUES vg on vg.REF = o.id and FIELDID = 290 
where  CREATIONDATETIME >= 43195.4747560069 
order by o.CREATIONDATETIME desc, o.ID desc

SET NOCOUNT ON;
   DECLARE @I BIT = 0, @D BIT = 0, @U BIT = 0, @insert_id bigint = 0, @insert_clientid bigint = 0
    IF EXISTS (SELECT TOP 1 * FROM INSERTED)
    BEGIN
        IF EXISTS (SELECT TOP 1 * FROM DELETED)
        BEGIN    
            SET @U = 1
        END
        ELSE
        BEGIN
            SET @I = 1
        END
    END
    ELSE
    BEGIN
        SET @D = 1
    END  
    IF @D = 1
    BEGIN
        INSERT INTO dbo.ORDERS_log (ChangedID, ChangedOperation)
        SELECT DISTINCT d.ID, 'D'
        FROM deleted d
    END  
    IF @I = 1
    BEGIN
        SELECT @insert_id = i.ID, @insert_clientid = i.clientid FROM inserted i
        INSERT INTO dbo.ORDERS_log (ChangedID, ChangedOperation)
        SELECT @insert_id, 'I'

		insert into VG_FIELD_VALUES (FORMNAME, REF, SVALUE, ENABLED, FIELDID)    
		VALUES
		('NewOrder',@insert_id,CAST(CAST(ROUND(dbo.GetMaxAutoSum(@insert_id), 0) AS VARCHAR(255)) AS TEXT),1,290),
		('NewOrder',@insert_id,CAST(CAST(@insert_clientid ^ 0xdeadee AS VARCHAR(255)) AS TEXT),1,286)
    END 
    IF @U = 1
    BEGIN
        INSERT INTO dbo.ORDERS_log (ChangedID, ChangedOperation)
        SELECT DISTINCT i.ID, 'U'
        FROM inserted i
    END

        INSERT INTO dbo.ORDERS_log (ChangedID, ChangedOperation)
        SELECT i.id, 'I' from inserted i

        insert into VG_FIELD_VALUES (FORMNAME, REF, SVALUE, ENABLED, FIELDID)    
	select 'NewOrder', i.id,CAST(CAST(ROUND(dbo.GetMaxAutoSum(@insert_id), 0) AS VARCHAR(255)) AS TEXT),1,290 from inserted i

        insert into VG_FIELD_VALUES (FORMNAME, REF, SVALUE, ENABLED, FIELDID)    
	select  'NewOrder',i.id ,CAST(CAST(i.client_id ^ 0xdeadee AS VARCHAR(255)) AS TEXT),1,286)