Project

Profile

Help

HostedRedmine.com has moved to the Planio platform. All logins and passwords remained the same. All users will be able to login and use Redmine just as before. Read more...

Bug #937695

Некорректный перевод текста СУБД в мета вариант

Added by Сергей Старых 18 days ago. Updated 3 days ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Анализ техножурнала
Sprint/Milestone:
Start date:
Due date:
% Done:

0%

Estimated time:

Description

UPDATE
    InfoRgSL5521
SET
    Period = RES.Period,
    Recorder = RES.Recorder,
        ...
FROM
(

SELECT InfoRg5488.Period,InfoRg5488.Recorder,InfoRg5488.Fld5489,InfoRg5488.Fld5490,InfoRg5488.Fld5491,InfoRg5488.Fld5492,InfoRg5488.Fld5506,InfoRg5488.Fld12794,InfoRg5488.Fld5498,InfoRg5488.Fld5499,InfoRg5488.Fld5501,InfoRg5488.Fld5497,InfoRg5488.Fld5507,InfoRg5488.Fld5500,InfoRg5488.Fld5517,InfoRg5488.Fld5514,InfoRg5488.Fld12795,InfoRg5488.Fld5496,InfoRg5488.Fld5494,InfoRg5488.Fld11694,InfoRg5488.Fld5503,InfoRg5488.Fld5504,InfoRg5488.Fld5510,InfoRg5488.Fld5512,InfoRg5488.Fld5513,InfoRg5488.Fld5495,InfoRg5488.Fld10367,InfoRg5488.Fld5493,InfoRg5488.Fld5502,InfoRg5488.Fld5511,InfoRg5488.Fld5505,InfoRg5488.Fld5508,InfoRg5488.Fld5518,InfoRg5488.Fld5515,InfoRg5488.Fld5516,InfoRg5488.Fld5509,InfoRg5488.Fld12796, InfoRg5488.Fld563
FROM
    (
        SELECT InfoRg5488.Fld5489, InfoRg5488.Fld5490, InfoRg5488.Fld5491, InfoRg5488.Fld5492,  MAX(InfoRg5488.Period) MINMAX_PERIOD
, InfoRg5488.Fld563
        FROM InfoRg5488
         INNER JOIN #TmpRecordSet ON
     InfoRg5488.Fld5489 = #TmpRecordSet.Fld5489
     AND  InfoRg5488.Fld5490 = #TmpRecordSet.Fld5490
     AND  InfoRg5488.Fld5491 = #TmpRecordSet.Fld5491
     AND  InfoRg5488.Fld5492 = #TmpRecordSet.Fld5492 AND  InfoRg5488.Fld563 = #TmpRecordSet.Fld563

        WHERE
InfoRg5488.Active=TRUE
        GROUP BY InfoRg5488.Fld5489, InfoRg5488.Fld5490, InfoRg5488.Fld5491, InfoRg5488.Fld5492, InfoRg5488.Fld563
    ) RES1 INNER JOIN InfoRg5488 ON 

            InfoRg5488.Fld5489=RES1.Fld5489
             AND InfoRg5488.Fld5490=RES1.Fld5490
             AND InfoRg5488.Fld5491=RES1.Fld5491
             AND InfoRg5488.Fld5492=RES1.Fld5492
             AND InfoRg5488.Fld563=RES1.Fld563
             AND InfoRg5488.Period=MINMAX_PERIOD
) RES
LEFT JOIN
InfoRgSL5521 ON
     InfoRgSL5521.Fld5489 = RES.Fld5489
     AND  InfoRgSL5521.Fld5490 = RES.Fld5490
     AND  InfoRgSL5521.Fld5491 = RES.Fld5491
     AND  InfoRgSL5521.Fld5492 = RES.Fld5492
     AND  InfoRgSL5521.Fld563 = RES.Fld563
WHERE
     InfoRgSL5521.Period < RES.Period

дает
...
        FROM РегистрСведений.упРаботыПоРейсу
         INNER JOIN #TmpRecordSet упРаботыПоРейсу_ИтогиСрезПоследних_ON
...

History

#1 Updated by Сергей Старых 18 days ago

  • Description updated (diff)

#2 Updated by Сергей Старых 3 days ago

  • Subject changed from Некорректный перевод текста СУБД в в мета to Некорректный перевод текста СУБД в мета варианте

#3 Updated by Сергей Старых 3 days ago

  • Subject changed from Некорректный перевод текста СУБД в мета варианте to Некорректный перевод текста СУБД в мета вариант

Also available in: Atom PDF