Miscellany

create view "ProjectVW" ( "ProjectId", "ProjectName", "CustomerId", "CustomerName", "Status", "TotalWelds", "TotalDrawings", "TotalSpools") as 	select c1."ProjectId", c1."ProjectName", c1."CustomerId", c2."CustomerName", c1."Status", dbo.GetWeldCountOnProject(c1."ProjectId"), dbo.GetProjectDrawingCount(c1."ProjectId"), dbo.GetProjectSpoolCount(c1."ProjectId")  	from "Project" c1, "Customer" c2  	where c1."CustomerId" = c2."CustomerId"  with check option