USE Tfs_DefaultCollection

Select tbl_projects.project_name as “Team Project”,

tbl_project_properties.value as “Process Template”

from tbl_projects

inner join tbl_project_properties

on tbl_projects.project_id = tbl_project_properties.project_id

where tbl_project_properties.name like ‘%Process Template%’

Advertisements