Articles in this section

See more

SQL Server query that retrieves the Model Names, Versions and LastModifiedDate from the Mart Server

Avatar
Matt Russo
Updated
Follow

SQL Server query that retrieves the Model Names, Versions and LastModifiedDate from the Mart Server:

SELECT ca.C_Name as ModelName_versionname,ca.C_Version,lm.LastModifiedDate FROM m9Catalog ca
LEFT OUTER JOIN (SELECT ca.C_Container_Id,ca.C_CreatedOn 'LastModifiedDate' FROM m9Catalog ca
WHERE ca.C_Id IN (SELECT MAX(C_Id) FROM m9Catalog GROUP BY C_Container_Id)
) lm ON
ca.C_Id = lm.C_Container_Id where ca.C_Type='D' or ca.C_Type='V'

 

Related articles

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk