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'
Comments
0 comments
Please sign in to leave a comment.