1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| select 'print '''+c.shortdesc +'.'+p.shortdesc+''' select '+c.shortdesc + '.'+p.shortdesc+', count(1) as Cnt from colibriresource..'+ c.shortdesc +
' join colibriresource..policyversion pv on pv.policyversionid = '+c.shortdesc+'.policyversionid and pv.policyversionid=
(select max(policyversionid) from
colibriresource..policyversion pv2 where pv2.policygeneralid=pv.policygeneralid) where ' + p.shortdesc + ' not in (' + pva.lookupacceptedvalueslist + ') group by ' + p.shortdesc ,
productattributename, pva.productattributeid, pva.isinput,
pva.isinputOldValue, pva.isinputLastValue, pva.lookuptablename,
pva.lookupacceptedvalueslist
from productversionattribute pva
join productattribute pa on pa.productattributeid=pva.productattributeid
join Luproductattributeclass c on c.productattributeclassid=pa.productattributeclassid
join luproductattributeproperty p on p.productattributepropertyid=pa.productattributepropertyid
join ProductAttributeMapping pm on pa.productattributeid=pm.productattributeid
where pva.productversionid = 11121201
and pva.lookuptablename is not null
and pva.lookuptablename != ''
and pva.lookupacceptedvalueslist !=''
and c.shortdesc not like 'PolicyVersion'
order by productattributename |
Partager