6 lines
283 B
SQL
6 lines
283 B
SQL
select dv.versionid, ff.name, .dbo.ve_getshortpathfromcontentid(cc.contentid) location
|
|
from contents cc
|
|
join vefn_getversionitems('') vv on vv.contentid = cc.contentid
|
|
join docversions dv on dv.versionid = vv.versionid
|
|
join folders ff on ff.folderid = dv.folderid
|
|
where type = 20010 |