eprintid: 227
rev_number: 28
eprint_status: archive
userid: 4
dir: disk0/00/00/02/27
datestamp: 2009-12-30 14:33:32
lastmod: 2016-05-27 21:03:46
status_changed: 2009-12-30 14:33:32
type: conference_item
metadata_visibility: show
item_issues_count: 0
creators_name: Thomas, Steve
title: Aleph Reports Combining SQL and Excel
ispublished: pub
subjects: aleph
divisions: eluna_conf
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. 
date: 2009-05-08
full_text_status: restricted
pres_type: speech
event_title: ELUNA 2009
event_location: Richmond, Va.
event_dates: 6-8 May 2009
event_type: conference
refereed: FALSE
citation: Thomas, Steve (2009) Aleph Reports Combining SQL and Excel. In: ELUNA 2009, 6-8 May 2009, Richmond, Va..
document_url: https://beta-documents.el-una.org/id/eprint/227/1/ELUNA_2009_A15a_ALL_Scripts.pdf
document_url: https://beta-documents.el-una.org/id/eprint/227/2/ELUNA_2009_A15a_Dup_Report_steps.pdf
document_url: https://beta-documents.el-una.org/id/eprint/227/3/ELUNA_2009_A15a_General_Excel_Tips.pdf
document_url: https://beta-documents.el-una.org/id/eprint/227/4/ELUNA_2009_A15a_Loan_Report_steps.pdf
document_url: https://beta-documents.el-una.org/id/eprint/227/5/ELUNA_2009_A15a_Periodicals_steps.pdf
document_url: https://beta-documents.el-una.org/id/eprint/227/6/ELUNA_2009_A15a_Premissions_steps.pdf
document_url: https://beta-documents.el-una.org/id/eprint/227/7/ELUNA_2009_A15a_Related_items_steps.pdf