TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
April Brown <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 23 Jun 2020 13:30:58 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (1537 bytes) , text/html (5 kB)
External Email - Exercise Caution
I just took that data scrubbing class (which was great) and one of the scripts Chad gave was this:

Select ObjectName, Count(*)
From Objects
Group by ObjectName
Having Count(*) = 1

It seems entirely possible to get this list of records into a Package in TMS but I don't know how to do it.  I already created the package I wanted to add the records to in TMS because I thought it would be easier than creating it in SQL. I thought it might be an Insert Into statement but I have never used one of those before.

Thanks,

April Brown
Registrar
The Charles Hosmer Morse Museum of American Art
Phone: (407) 645-5311  x. 105  |   Fax: (407) 647-1284
https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.morsemuseum.org%2F&amp;data=02%7C01%7Ctmsusers%40si-listserv.si.edu%7C31c7de2fffee40f6b58808d81779ac77%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C1%7C637285158646962221&amp;sdata=P8j%2BeG7xVvErrc1kialn571CgTfsaOIxd8GW%2FnSjfIk%3D&amp;reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.morsemuseum.org%2F&amp;data=02%7C01%7Ctmsusers%40si-listserv.si.edu%7C31c7de2fffee40f6b58808d81779ac77%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C1%7C637285158646962221&amp;sdata=P8j%2BeG7xVvErrc1kialn571CgTfsaOIxd8GW%2FnSjfIk%3D&amp;reserved=0>


To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.


ATOM RSS1 RSS2