ELUNA Document Repository

Aleph Reports Combining SQL and Excel

Thomas, Steve (2009) Aleph Reports Combining SQL and Excel. In: ELUNA 2009, 6-8 May 2009, Richmond, Va..

[img] PDF (All Scripts) - Supplemental Material
Restricted to Registered users only

67kB
[img] PDF (Using Excel to Prepare a Report of Duplicate Books) - Supplemental Material
Restricted to Registered users only

202kB
[img] PDF (General Excel Tips) - Supplemental Material
Restricted to Registered users only

1MB
[img] PDF (Using Excel to Prepare a Loan Report) - Supplemental Material
Restricted to Registered users only

571kB
[img] PDF (Using Excel with Data from the Serial/Periodicals Script) - Supplemental Material
Restricted to Registered users only

907kB
[img] PDF (Using Excel with Output from Permissions Script) - Supplemental Material
Restricted to Registered users only

455kB
[img] PDF (Using Excel to Prepare a “Related Items” Report) - Supplemental Material
Restricted to Registered users only

224kB

Abstract

Steve Thomas, Local Systems Development Coordinator, University of Tennessee. This presentation will show how a few simple SQL scripts, when combined with the sort and compare features of Excel, may be used to prepare some powerful reports. For example, in answer to a request for a report of duplicate holdings, the presenter was able to reduce the initial output file of over 69,000 book items into a report of less than 12,000 duplicate items by comparing call number and description data.

Item Type:Conference or Workshop Item (Speech)
Event Title:ELUNA 2009
Subjects:Aleph
Divisions:ELUNA Conference Proceedings
ID Code:227
Deposited By:INVALID USER
Deposited On:30 Dec 2009 14:33
Last Modified:27 May 2016 21:03

Repository Staff Only: item control page