Untitled
unknown
plain_text
a year ago
782 B
6
Indexable
--select * from mrms.lg_masterParamSetComponents lmpsc; -- --select * from mrms.lg_masterParamSetComponents lmpsc --where relationId in (42,44,46); update mrms.lg_masterParamSetComponents set isHeader = 0, isActive = 0 where relationId in (42,44,46); --select * from mrms.lg_masterParamSetComponents lmpsc --where relationId in (43,45,47); update mrms.lg_masterParamSetComponents set parent = 0 where relationId in (43,45,47); --select * from mrms.lg_paramSetComponents lpsc --where --lpsc.relationId in (42,43,44,45,46,47) --and lpsc.parameterId = 6; update mrms.lg_parameters set status = 'DRAFTED' where id = 2; update mrms.lg_paramSetComponents set parentId = 0, isActive = 1, isHeader = 0, isDeleted = 0 where relationId in (42,43,44,45,46,47) and parameterId = 2;
Editor is loading...
Leave a Comment