%0 Conference Paper %A Thomas, Steve %B ELUNA 2009 %C Richmond, Va. %D 2009 %F eluna:227 %T Aleph Reports Combining SQL and Excel %U https://beta-documents.el-una.org/id/eprint/227/ %X 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.