I used this query to count Total Assets per project from the database:
Select Count(TPNAME) as "Total Asset", TPASSOCIATEDPROJECTID as "Project ID"
Group By TPASSOCIATEDPROJECTID
Now I need to limit the assets to Visual Test & .NET only, Could I know how to do that?
In the table design, there is TPOBJECTTYPE but its type is Integer and it doesn't have a relation with another database.