<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Gill Sans MT";
panose-1:2 11 5 2 2 1 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Gill Sans MT","sans-serif";
color:#5F497A;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="Section1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">Greetings colleagues, we recently created a test database for our other campus’ library staff to trial. Unfortunately, the data that was loaded into
the test database was the same messed up data. Fortunately, after making a backup, my geek was able to run both SQL solutions, one on each database. I could then view the results and pick the outcome that I liked best.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">I wish I had thought to get screenshots to better show the differences with the two SQLs as applied to our situation. If we had not reissued so many
items with anonymous checkout information (NULL values), the other shorter SQL would have been better. For our particular situation, Galen’s SQL had better results.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">We reissued about 150 items with anonymous checkout information (NULL values) and Galen’s SQL linked reissued items to their current borrowers. The other
SQL resulted in every item with a NULL to be issued to a fictitious borrower; this affected overdue items and well as items that had been returned or reissued.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">Galen’s SQL resulted in overdue items with NULL values showing as available in the catalog, those items are no longer on overdue lists and doing an inventory
will be beneficial. Informal evidence indicates that there are a small number of items on “permanent loan” and while these overdue items appear as available, they can be updated or removed now. While some data is lost, it is a minor inconvenience compared
to what we had.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">An interesting discovery after running the SQL is that searches resulting in more than one record where there is a formerly NULL item, the item displays
as checked out but the detail view shows the item as available.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">Screen shots are at:
<a href="http://home.earthlink.net/~rhollis/Koha/afterSQL.pdf">http://home.earthlink.net/~rhollis/Koha/afterSQL.pdf</a>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">Rachel Hollis, librarian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">Stevens-Henager College, Boise Idaho Campus</span>
<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font face="Verdana" color="Gray" size="1">This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original.
Any other use of the email by you is prohibited.<br>
</font>
</body>
</html>