select p.projectname, c.customername, w.welderid, wt.weldtypename, wtt.testtypename,
 
(select count(ws.statusname) from weldStatus ws where statusName like ('Reweld')) 'Number of Rewelds', 

wp.procedurename, smdc.name, weld.weldid, weld.welderid, tr.result, tcod.Data,

(select Count(wtt.testtypename)
from WeldTestType wtt
where wtt.testTypeName like ('X-Ray')) as 'Number of Welds X-Rayed',

(select count(weld.welderid)/(select Count(wal.weldStatusId) from weldActivityLog wal, weld where weld.weldId = wal.weldId and 
wal.weldstatusId = 5) 
from weld, weldActivityLog wal
where weld.weldId = wal.weldId) 'Repair Percent Per Welder'

from project p,customer c,welder w, employee e, projectemployee pe, weldtype wt, weld,weldtesttype wtt, weldtest wtest,
weldstatus ws, weldactivitylog wal,weldprocedure wp,specificationmatrixdatacolumn smdc, specificationMatrix sm, 
projectspecificationMatrix psm, testresult tr, testColumnObjectData tcod, specification spec

where p.customerid = c.customerid and p.projectid = pe.projectid and 
pe.employeeid = e.employeeid and 
e.employeeid = w.employeeid and
wt.weldtypeid = weld.weldtypeid and
weld.welderid = w.welderid and
wtt.weldtesttypeid = wtest.weldtesttypeid and
wtest.weldid = weld.weldid and 
ws.weldstatusid = wal.weldstatusid and 
wal.weldid = weld.weldid and 
wp.weldprocedureid = weld.weldprocedureid and
smdc.specificationmatrixid = sm.specificationmatrixid and 
sm.specificationmatrixid = psm.specificationmatrixid and
psm.projectId = p.projectId and 
tr.testresultid = wtest.testresultid and
tcod.SpecificationId = Spec.SpecificationId and 
spec.WeldProcedureId = Wp.WeldProcedureId and 

c.customerName = @CustomerName and 
p.projectName = @projectName