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

 

 

 

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] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

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