September 4, 2024 at 10:25 pm
hello friends
update mkf set mkf.Score= mkf.score -
(
select sum(pp.ScoreInScale) from Progresses pp
where pp.MemberKnowledgeFieldId = mkf.Id
and pp.KnowledgeId in
(select k.KnowledgeId from knowledges k where k.Code in
(
8396
,8395
,7999
,7723
,7751
,7753
,8069
,362
,7733
,7993
,8379
,7736
)
)
)
FROM NewKms_MECO..MemberKnowledgeFields mkf
where mkf.Id in
(select p.MemberKnowledgeFieldId from Progresses p
where p.KnowledgeId in
(
select k.KnowledgeId from knowledges k where k.Code in
(
8396
,8395
,7999
,7723
,7751
,7753
,8069
,362
,7733
,7993
,8379
,7736
)
)
)
September 5, 2024 at 7:48 am
September 25, 2024 at 8:03 am
For readability I suggest indents , but more importantly this looks like it could use EXISTS clauses and not sure why the same values criteria appear more than once.
----------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy