We have this view, but I'm not sure the best way to send it?

SELECT     TOP (100) PERCENT ObjectID AS ID, ObjectNumber, SortNumber, ObjectName, Dated, Title AS [Scott Number], Medium, CreditLine, Description,
                      dbo.Concat_LocationString(ObjectID, 1) AS Location, ObjectCount
FROM         dbo.Objects AS O
ORDER BY SortNumber

Caitlin Badowski
TMS Administrator
Smithsonian National Postal Museum
2 Massachusetts Avenue NE, MRC 570
Washington, DC 20013-7012
(202) 633-8735
[log in to unmask]<mailto:[log in to unmask]>
[NPM Logo for Signature Block]

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Rob Morgan
Sent: Friday, April 01, 2016 11:24 AM
To: [log in to unmask]
Subject: Current Location in a List View

Hello TMS Community,

Has anybody successfully placed current location in a list view?  If so, can you send me the SQL script?

Thanks everyone,
Rob Morgan
Collections Database Administrator
The Baltimore Museum of Art
To unsubscribe, send an email to [log in to unmask]<mailto:[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.

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.