[PulseNet Africa] PulseNet Quick Tips: Database Cleaning Series, Part 3- Duplicate Keys

Wed May 10 07:43:55 SAST 2017



From: PulseNet (CDC) [mailto:pulsenet at cdc.gov]
Sent: 09 May 2017 07:18 PM
To: PulseNet (CDC)
Subject: PulseNet Quick Tips: Database Cleaning Series, Part 3- Duplicate Keys


[cid:image001.jpg at 01D2C8C6.B3C1D470]


[cid:image002.jpg at 01D2C8C6.B3C1D470]


[cid:image003.jpg at 01D2C8C6.B3C1D470]


[cid:image004.jpg at 01D2C8C6.B3C1D470]


[cid:image005.jpg at 01D2C8C6.B3C1D470]


[cid:image006.jpg at 01D2C8C6.B3C1D470]


[cid:image007.jpg at 01D2C8C6.B3C1D470]


[cid:image008.jpg at 01D2C8C6.B3C1D470]


[cid:image009.jpg at 01D2C8C6.B3C1D470]


[cid:image010.jpg at 01D2C8C6.B3C1D470]


[cid:image011.jpg at 01D2C8C6.B3C1D470]


[cid:image012.jpg at 01D2C8C6.B3C1D470]


[cid:image013.jpg at 01D2C8C6.B3C1D470]


[cid:image014.jpg at 01D2C8C6.B3C1D470]


[cid:image015.jpg at 01D2C8C6.B3C1D470]


[cid:image016.jpg at 01D2C8C6.B3C1D470]


[cid:image017.jpg at 01D2C8C6.B3C1D470]


[cid:image018.jpg at 01D2C8C6.B3C1D470]


[cid:image019.jpg at 01D2C8C6.B3C1D470]


[cid:image020.jpg at 01D2C8C6.B3C1D470]


The views expressed in this email are, unless otherwise stated, those of the author and not those of the National Health Laboratory Service or its management. The information in this e-mail is confidential and is intended solely for the addressee.
Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is, for whatever reason, corrupted or does not reach its intended destination.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 38765 bytes
Desc: image001.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0020.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 1985 bytes
Desc: image002.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0021.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 9829 bytes
Desc: image003.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0022.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 21449 bytes
Desc: image004.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0023.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 3732 bytes
Desc: image005.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0024.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.jpg
Type: image/jpeg
Size: 12097 bytes
Desc: image006.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0025.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.jpg
Type: image/jpeg
Size: 19547 bytes
Desc: image007.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0026.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image008.jpg
Type: image/jpeg
Size: 9101 bytes
Desc: image008.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0027.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.jpg
Type: image/jpeg
Size: 34150 bytes
Desc: image009.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0028.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image010.jpg
Type: image/jpeg
Size: 23726 bytes
Desc: image010.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0029.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image011.jpg
Type: image/jpeg
Size: 12119 bytes
Desc: image011.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0030.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image012.jpg
Type: image/jpeg
Size: 22825 bytes
Desc: image012.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0031.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image013.jpg
Type: image/jpeg
Size: 15568 bytes
Desc: image013.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0032.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image014.jpg
Type: image/jpeg
Size: 15342 bytes
Desc: image014.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0033.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image015.jpg
Type: image/jpeg
Size: 67470 bytes
Desc: image015.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0034.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image016.jpg
Type: image/jpeg
Size: 6495 bytes
Desc: image016.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0035.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image017.jpg
Type: image/jpeg
Size: 11487 bytes
Desc: image017.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0036.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image018.jpg
Type: image/jpeg
Size: 2704 bytes
Desc: image018.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0037.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image019.jpg
Type: image/jpeg
Size: 417 bytes
Desc: image019.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0038.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image020.jpg
Type: image/jpeg
Size: 9967 bytes
Desc: image020.jpg
URL: <http://lists.wits.ac.za/pipermail/pulsenetafrica/attachments/20170510/ca8eed61/attachment-0039.jpg>