RE: Spool
"Simoneau, Roger" <[email protected]> Mon, 22 Jul 2013 12:56:30 -0600
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <85214F3A9C2FE94F9FF1D7C6456E33F910FB072649@EX-CLUS-MBX-01.abcp.ab.bluecross.ca> |
--_000_85214F3A9C2FE94F9FF1D7C6456E33F910FB072649EXCLUSMBX01ab_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable In that case, since it's also expected to be a one-time script: Add the date to your select statements and group by the date. Select pstore_open_date, count(*) From store Where pstore_date between trunk(sysdate) - 30 and trunc(sysdate) Group by pstore_open_date Roger A. Simoneau Systems Analyst Alberta Blue Cross (780) 498-8837 From: [email protected] [mailto:[email protected]] On Behalf Of SHIVA= NAND BHARTI Sent: Monday, July 22, 2013 12:08 PM To: [email protected] Subject: RE: [toad] Spool To keep it simple let's say last 30 days ... sysdate, sysdate - 1 , sysdate= -2,...,sysdate-29 Thanks, Shiva From: [email protected]<mailto:[email protected]> [mailto:toad@yahoog= roups.com] On Behalf Of gene.l.bradley Sent: Monday, July 22, 2013 1:43 PM To: [email protected]<mailto:[email protected]> Subject: Re: [toad] Spool How are you determining what the dates are. You could put the dates in a temporary table and then say where dateVariable in (select myDate from temp_table); On Mon, Jul 22, 2013 at 12:31 PM, SHIVANAND BHARTI <[email protected]= m<mailto:[email protected]>> wrote: Hi folks ... I have a query with bind variable which accepts date. How can I run thais query for 30 different dates and get it's output in a f= ile. I can write the same query 30 times with different date and run it as ascri= pt. Or write a PL/SQL block. But it is an one time thing and I am looking for something quick . Is there an option in Toad by which I can spool out the output of a query f= or different input for the same bind variable ? For example how can I run this query for 30 different dates and spool it's= output. SELECT :RunDate , ( SELECT COUNT(*) FROM store WHERE pstore_open_date =3D:RunDate ) store_count ,( SELECT COUNT(*) FROM wh WHERE wh_open_date =3D:RunDate ) ) wh_count FROM dual; Thanks, Shiva ---------------------------------------------------------------------------= ---------- NOTE: This e-mail message contains PRIVILEGED and CONFIDENTIAL information = and is intended only for the use of the specific individual or individuals = to which it is addressed. If you are not an intended recipient of this e-ma= il, you are hereby notified that any unauthorized use, dissemination or cop= ying of this e-mail or the information contained herein or attached hereto = is strictly prohibited. If you receive this e-mail in error, notify the per= son named above by reply e-mail and please delete it. Thank you. -- Gene L. Bradley Jr. Software Developer I Information Systems & Integration Jackson State University 1400 J R Lynch Street P.O. Box 17750 Jackson, MS 39217 ph 601.979.1042 fax 601.371.9146 email [email protected]<mailto:[email protected]> ---------------------------------------------------------------------------= ---------- NOTE: This e-mail message contains PRIVILEGED and CONFIDENTIAL information = and is intended only for the use of the specific individual or individuals = to which it is addressed. If you are not an intended recipient of this e-ma= il, you are hereby notified that any unauthorized use, dissemination or cop= ying of this e-mail or the information contained herein or attached hereto = is strictly prohibited. If you receive this e-mail in error, notify the per= son named above by reply e-mail and please delete it. Thank you. ________________________________ This communication, including any attached documentation, is intended only = for the person or entity to which it is addressed, and may contain confiden= tial, personal and/or privileged information. Any unauthorized disclosure, = copying, or taking action on the contents is strictly prohibited. If you ha= ve received this message in error, please contact us immediately so we may = correct our records. Please then delete or destroy the original transmissio= n and any subsequent reply. --_000_85214F3A9C2FE94F9FF1D7C6456E33F910FB072649EXCLUSMBX01ab_ Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: 7bit <head> <style type="text/css"> <!-- /* start of attachment style */ .ygrp-photo-title{ clear: both; font-size: smaller; height: 15px; overflow: hidden; text-align: center; width: 75px; } div.ygrp-photo{ background-position: center; background-repeat: no-repeat; background-color: white; border: 1px solid black; height: 62px; width: 62px; } div.photo-title a, div.photo-title a:active, div.photo-title a:hover, div.photo-title a:visited { text-decoration: none; } div.attach-table div.attach-row { clear: both; } div.attach-table div.attach-row div { float: left; /* margin: 2px;*/ } p { clear: both; padding: 15px 0 3px 0; overflow: hidden; } div.ygrp-file { width: 30px; valign: middle; } div.attach-table div.attach-row div div a { text-decoration: none; } div.attach-table div.attach-row div div span { font-weight: normal; } div.ygrp-file-title { font-weight: bold; } /* end of attachment style */ --> </style> </head> <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: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)"> <!--[if !mso]><style>v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style><![endif]--><style><!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @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:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} /* 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 {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} code {mso-style-priority:99; font-family:"Courier New";} pre {mso-style-priority:99; mso-style-link:"HTML Preformatted Char"; margin:0in; margin-bottom:.0001pt; font-size:10.0pt; font-family:"Courier New";} tt {mso-style-priority:99; font-family:"Courier New";} 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.cat {mso-style-name:cat;} span.ct {mso-style-name:ct;} span.HTMLPreformattedChar {mso-style-name:"HTML Preformatted Char"; mso-style-priority:99; mso-style-link:"HTML Preformatted"; font-family:"Consolas","serif";} p.attach, li.attach, div.attach {mso-style-name:attach; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:9.0pt; font-family:"Arial","sans-serif";} p.bold, li.bold, div.bold {mso-style-name:bold; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:10.0pt; font-family:"Arial","sans-serif"; font-weight:bold;} p.green, li.green, div.green {mso-style-name:green; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif"; color:#628C2A;} p.replbq, li.replbq, div.replbq {mso-style-name:replbq; margin:3.0pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.ad, li.ad, div.ad {mso-style-name:ad; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.underline, li.underline, div.underline {mso-style-name:underline; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} span.yshortcuts {mso-style-name:yshortcuts;} p.ad1, li.ad1, div.ad1 {mso-style-name:ad1; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.ad2, li.ad2, div.ad2 {mso-style-name:ad2; mso-margin-top-alt:auto; margin-right:0in; margin-bottom:7.5pt; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.underline1, li.underline1, div.underline1 {mso-style-name:underline1; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif"; text-decoration:underline;} span.yshortcuts1 {mso-style-name:yshortcuts1; font-family:"Verdana","sans-serif"; font-weight:bold;} span.yshortcuts2 {mso-style-name:yshortcuts2; font-family:"Verdana","sans-serif"; font-weight:normal;} span.EmailStyle36 {mso-style-type:personal-reply; font-family:"Courier New"; color:#1F497D; font-weight:normal; font-style:normal;} span.BalloonTextChar {mso-style-name:"Balloon Text Char"; mso-style-priority:99; mso-style-link:"Balloon Text"; font-family:"Tahoma","sans-serif";} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:1329136283; mso-list-template-ids:1022135686;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:\F0B7; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} --></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 bgcolor="white" lang="EN-US" link="blue" vlink="purple"> <div class="WordSection1"> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">In that case, since it's also expected to be a one-time script:<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D"><o:p> </o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">Add the date to your select statements and group by the date.<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D"><o:p> </o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">Select pstore_open_date, count(*)<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">From store<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">Where pstore_date between trunk(sysdate) - 30 and trunc(sysdate)<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">Group by pstore_open_date<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D"><o:p> </o:p></span></p> <div> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">Roger A. Simoneau<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">Systems Analyst<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">Alberta Blue Cross<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D">(780) 498-8837<o:p></o:p></span></p> </div> <p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#1F497D"><o:p> </o:p></span></p> <div> <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"> <p class="MsoNormal" style="margin-left:.5in"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> [email protected] [mailto:[email protected]] <b>On Behalf Of </b>SHIVANAND BHARTI<br> <b>Sent:</b> Monday, July 22, 2013 12:08 PM<br> <b>To:</b> [email protected]<br> <b>Subject:</b> RE: [toad] Spool<o:p></o:p></span></p> </div> </div> <p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p> <p class="MsoNormal" style="margin-left:.5in"> <o:p></o:p></p> <div id="ygrp-mlmsg"> <div id="ygrp-msg"> <div id="ygrp-text"> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="font-size:11.0pt;color:#1F497D">To keep it simple let’s say last 30 days … sysdate, sysdate – 1 , sysdate -2,…,sysdate-29</span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="font-size:11.0pt;color:#1F497D"> </span><o:p></o:p></p> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="font-size:11.0pt;color:#1F497D">Thanks,</span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="font-size:11.0pt;color:#1F497D">Shiva</span><o:p></o:p></p> </div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="font-size:11.0pt;color:#1F497D"> </span><o:p></o:p></p> <div> <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:0in 0in 0in 0in"> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt"> <a href="mailto:[email protected]">[email protected]</a> [<a href="mailto:[email protected]">mailto:[email protected]</a>] <b>On Behalf Of </b>gene.l.bradley<br> <b>Sent:</b> Monday, July 22, 2013 1:43 PM<br> <b>To:</b> <a href="mailto:[email protected]">[email protected]</a><br> <b>Subject:</b> Re: [toad] Spool</span><o:p></o:p></p> </div> </div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <div id="ygrp-mlmsg"> <div id="ygrp-msg"> <div id="ygrp-text"> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> How are you determining what the dates are.<o:p></o:p></p> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> You could put the dates in a temporary table<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> and then say where dateVariable in (select myDate from temp_table);<o:p></o:p></p> </div> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> On Mon, Jul 22, 2013 at 12:31 PM, SHIVANAND BHARTI <<a href="mailto:[email protected]" target="_blank">[email protected]</a>> wrote:<o:p></o:p></p> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <div> <div> <div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Hi folks … I have a query with bind variable which accepts date.<o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> How can I run thais query for 30 different dates and get it’s output in a file.<o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> I can write the same query 30 times with different date and run it as ascript.<o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Or write a PL/SQL block.<o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> But it is an one time thing and I am looking for something quick .<o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Is there an option in Toad by which I can spool out the output of a query for different input for the same bind variable ?<o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> For example how can I run this query for 30 different dates and spool it’s output.<o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="color:#1F497D">SELECT :RunDate ,</span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="color:#1F497D"> ( SELECT COUNT(*) </span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="color:#1F497D"> FROM store </span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="color:#1F497D"> WHERE pstore_open_date =:RunDate ) store_count </span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="color:#1F497D"> ,( SELECT COUNT(*) </span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="color:#1F497D"> FROM wh </span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="color:#1F497D"> WHERE wh_open_date =:RunDate ) ) wh_count</span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <span style="color:#1F497D"> FROM dual;</span><o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Thanks,<o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Shiva<o:p></o:p></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> </div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <br clear="all"> ------------------------------------------------------------------------------------- <o:p></o:p></p> <p style="margin-left:.5in">NOTE: This e-mail message contains PRIVILEGED and CONFIDENTIAL information and is intended only for the use of the specific individual or individuals to which it is addressed. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, dissemination or copying of this e-mail or the information contained herein or attached hereto is strictly prohibited. If you receive this e-mail in error, notify the person named above by reply e-mail and please delete it. Thank you. <o:p></o:p></p> </div> </div> </div> </div> </div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <br> <br clear="all"> <o:p></o:p></p> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> </div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> -- <o:p></o:p></p> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Gene L. Bradley Jr.<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Software Developer I<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Information Systems & Integration<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Jackson State University<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> 1400 J R Lynch Street<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> P.O. Box 17750<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> Jackson, MS 39217<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> ph 601.979.1042<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> fax 601.371.9146<o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> email <a href="mailto:[email protected]" target="_blank">[email protected]</a><o:p></o:p></p> </div> <div> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"> <o:p></o:p></p> </div> </div> </div> </div> <p class="MsoNormal" style="margin-left:.5in"><br clear="all"> ------------------------------------------------------------------------------------- <o:p></o:p></p> <p style="margin-left:.5in">NOTE: This e-mail message contains PRIVILEGED and CONFIDENTIAL information and is intended only for the use of the specific individual or individuals to which it is addressed. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, dissemination or copying of this e-mail or the information contained herein or attached hereto is strictly prohibited. If you receive this e-mail in error, notify the person named above by reply e-mail and please delete it. Thank you. <o:p></o:p></p> </div> </div> </div> <div> <p class="MsoNormal" style="margin-left:.5in"><span style="color:white"><o:p></o:p></span></p> </div> </div> <br> <hr> <font face="Arial" color="Gray" size="2">This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.<br> </font> <!-- |**|begin egp html banner|**| --> <br> <br> <!-- |**|end egp html banner|**| --> <div width="1" style="color: white; clear: both;"/>__._,_.___</div> <!-- Start Recommendations --> <!-- End Recommendations --> <!-- |**|begin egp html banner|**| --> <img src="http://geo.yahoo.com/serv?s=97476590/grpId=1103546/grpspId=1705115368/msgId=58542/stime=1374519401" width="1" height="1"> <br> <!-- |**|end egp html banner|**| --> <!-- |**|begin egp html banner|**| --> <br> <div style="font-family: verdana; font-size: 77%; border-top: 1px solid #666; padding: 5px 0;" > Your email settings: Individual Email|Traditional <br> <a href="http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmZGdzaWYyBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEzNzQ1MTk0MDE-">Change settings via the Web</a> (Yahoo! ID required) <br> Change settings via email: <a href="mailto:[email protected]?subject=Email Delivery: Digest">Switch delivery to Daily Digest</a> | <a href = "mailto:[email protected]?subject=Change Delivery Format: Fully Featured">Switch to Fully Featured</a> <br> <a href="http://groups.yahoo.com/group/toad;_ylc=X3oDMTJkZ2QxMDl1BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMzc0NTE5NDAx"> Visit Your Group </a> | <a href="http://docs.yahoo.com/info/terms/"> Yahoo! Groups Terms of Use </a> | <a href="mailto:[email protected]?subject=Unsubscribe"> Unsubscribe </a> <br> </div> <br> <!-- |**|end egp html banner|**| --> <div style="color: white; clear: both;"/>__,_._,___</div> </body> </html> --_000_85214F3A9C2FE94F9FF1D7C6456E33F910FB072649EXCLUSMBX01ab_--