SourceCode/PROMS/SQL/FindROlinkCharB4.sql

7 lines
283 B
SQL

--select * from vefn_getversionnames()
select *, substring(text, charindex('<START]', text)-5, 20) strt
from vefn_getversionitems('13,14,15,16') vi
join contents cc on cc.contentid = vi.contentid
join rousages ru on ru.contentid = cc.contentid
where versionid in (13, 14, 15, 16)