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.


April Brown
The Charles Hosmer Morse Museum of American Art
Phone: (407) 645-5311  x. 105  |   Fax: (407) 647-1284

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.