Have you ever wanted to use the TFS 2010 data warehouse for retrieving the unit test pass/fail count for a specific build? Maybe you wanted a report showing the number of unit tests that ran during each nightly build last week. In any case, if you wanted this or something similar, you soon found out an interesting fact – picking out only unit tests from the warehouse is not trivial. Here is the query for doing this: SELECT BuildName AS 'Build', COALESCE([Passed],0...