pw-dk.sql

SELECT *,V.CHILD_NAME AS [Belge Adı],S.FILE_FORMAT AS [BELGE FORMATI],C.PAGE_COUNT AS [SAYFA SAYISI], (C.CONTENT_SIZE/1024) AS [DOSYA BOYUTU (Kb)]
from PW_VIRTUAL_DOCS V WITH (NOLOCK), [VW_T_MALI_ISLER_ARSIV] T WITH (NOLOCK) , PW_SYSOBJECT S WITH (NOLOCK), PW_CONTENT C WITH (NOLOCK)
WHERE T.OBJECT_ID=V.OBJECT_ID AND
V.CHILD_ID=S.OBJECT_ID AND
S.CONTENT_ID=C.CONTENT_ID AND
V.CONTENT_TYPE='D'