Y:\Copyright & Permission\Digital\PDF\Notification PDF Letter
Diana N. Mangowal says:
Y:\Digital Project\PDF\PDF Selection

SELECT id, lccn, title, country_id, pub as institution, phisc_desc as physical_desc, url, approved_dt, approved_by, annotation, year_pub

FROM PDFArchives_MATERIALS

WHERE approved = '1'

AND dbo.trunc(approved_dt) between dbo.trunc('20111001') AND dbo.trunc('20121001')

order by title
+++++++++++++++++++++++++++++++++++++++++

SELECT PDFArchives_MATERIALS.ID, 
PDFArchives_MATERIALS.LCCN, 
PDFArchives_MATERIALS.TITLE, 
PDFArchives_MATERIALS.COUNTRY_ID AS COUNTRY,
PDFArchives_MATERIALS.PUB AS INSTITUTION, 
PDFArchives_MATERIALS.URL,
PDFArchives_MATERIALS.PHISC_DESC AS PHYSICAL_DESC,
PDFArchives_EMAIL_SENT.SEND_DT, 
PDFArchives_MATERIALS.ANNOTATION,
PDFArchives_MATERIALS.YEAR_PUB

FROM PDFArchives_MATERIALS
LEFT OUTER JOIN PDFArchives_EMAIL_SENT ON PDFArchives_MATERIALS.ID = PDFArchives_EMAIL_SENT.recid

WHERE(PDFArchives_MATERIALS.APPROVED = '1') AND (dbo.Trunc(PDFArchives_MATERIALS.APPROVED_DT) BETWEEN dbo.Trunc('20111001') AND dbo.Trunc('20121001'))

ORDER BY TITLE


+++++++++++++++++++++++++++++++++++++++++

SELECT     ID, ORD_ID, REC_DT, COPY, TRANSC_NO, USR_CRE, INV_NO, CRE_DT, USR_UPD, UPD_DT, ORD_TYPE, REC_NOTE, ISBN, RECID_ORD, 
                      RECID_REC, INV_DT, PROC_DT, PROC_USR, PROC_STA
FROM         BOOKS_RECEIVED
WHERE     (dbo.Trunc(REC_DT) BETWEEN dbo.Trunc('20110101') AND dbo.Trunc('20120930')) AND (ID IN
                          (SELECT     ID
                            FROM          BOOKS_RECEIVED_DTL
                            WHERE      (PART = '16') AND (dbo.Trunc(REC_DT) BETWEEN dbo.Trunc('20110101') AND dbo.Trunc('20110930')))) AND (ID IN
                          (SELECT     ID
                            FROM          BOOKS
                            WHERE      (COUNTRY_ID = 'MY')))


++++++++++++++++++++++++++++++++++++++++++
SELECT

ID AS REC_ID, COUNTRY_ID, LCCN, TITLE, USR_UPD AS UPDATE_BY, UPD_DT AS UPDATE_DATE, STA_CD AS STATUS

FROM PDFArchives_MATERIALS
WHERE (STA_CD = '2') AND (dbo.Trunc(UPD_DT) BETWEEN dbo.Trunc('20121201') AND dbo.Trunc('20121231')) AND (USR_UPD = 'dan')

ORDER BY COUNTRY_ID