------------query to get the node counts for each project when "calculate all" button is clicked--------

--For all Projects
select COUNT(ID),ProjectID from TreeviewObject
where ProjectID IN(
					select ID from Project  where InCalculation=1 and MatrixVariableID>0)
					and ProjectID IN(
						select projectID from ProjectCollaborator  WHERE CollaboratorID=99 AND (Rights=1 OR Rights =2))

Group By ProjectID

--For One Project
select COUNT(ID) from Rep_TreeviewObject where TreeviewObjectID IN(select ID from TreeviewObject where ProjectID =59)