Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
615 B
2
Indexable
Never
-- 1
select parameterId, relationId from mrms.lg_paramSetComponents lmpsc 
join mrms.lg_parameters lp on lmpsc.parameterId = lp.id 
where 
	cast(lmpsc.name as varchar) = 'giro' 
and componentType = 'pasiva'
and lp.isDeleted = 0;

-- 2
select parameterId, relationId from mrms.lg_paramSetComponents lmpsc 
join mrms.lg_parameters lp on lmpsc.parameterId = lp.id 
where 
	cast(lmpsc.name as varchar) = 'kewajiban lain-lain' 
and componentType = 'pasiva'
and lp.isDeleted = 0;

-- 3
select id, name from mrms.lg_parameters lp 
where lp.isDeleted = 0;

-- 4
update mrms.lg_reports set isDeleted = 1 where isDeleted = 0;
Leave a Comment