15 lines
972 B
SQL
15 lines
972 B
SQL
--Find Bad formatted links (Transitions or Referenced Objects) which can be fixed by running FixBadLinkFormatStartStart.sql
|
|
select VN.* , Vi.ItemID, dbo.ve_GetShortPath(VI.ItemID) Location from vefn_GetVersionProcedureItems('') vi
|
|
JOIN VEFN_GetVersionNames() VN ON VI.VersionID = VN.VersionID
|
|
JOIN Contents CC ON VI.ContentID = CC.ContentID
|
|
where VI.ContentID IN(select ContentID from ( select ContentID, StartCount,EndCount,StartStartCount,EndEndCount
|
|
, case when StartCount=EndCount and StartStartCount = 0 and EndEndCount = 0 then 0
|
|
when StartCount = EndCount+StartStartCount and EndEndCount = 0 then 1
|
|
else 2 end Stat
|
|
from (
|
|
select ContentID
|
|
, (Len(text)-len(replace(text,'<START]','')))/7 StartCount
|
|
, (Len(text)-len(replace(text,'[END>','')))/5 EndCount
|
|
, (Len(text)-len(replace(text,'<START]<START]','')))/14 StartStartCount
|
|
, (Len(text)-len(replace(text,'[END>[END>','')))/10 EndEndCount
|
|
From Contents) T1 ) t2 Where Stat= 1) Order By vi.VersionId,ProcId,Location |