With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
SELECT Table1.Name CONVERT(varchar,Table2.Date,101) as Date FROM Table1 LEFT OUTER JOIN Table2 ON Table1.Name = Table2.Table1$Name LEFT OUTER JOIN Table3 ON Table2.Table3$id = Table3.id WHERE Table2.Date IN ( SELECT MAX(Date) FROM Table2 x WHERE Table1.name = x.Table1$name AND x.Table3$id = Table3.id AND Table3.IsActive = 'N' )
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!