Here's a static version of your "report" (this would be the data behind the report actually)
select conid,location,[cert1date],[cert2date],[cert3date],[cert4date]
from
(select #table1.conid, location, certdesc+'date' certname,certdate
from #table1
cross join #table3
left outer join #table2 on #table1.conid=#table2.conid and #table3.certdesc=#table2.[cert]
where exists (select null from #table2 where conid=#table1.conid)
) p
pivot
(max(certdate) for certname in ([cert1date],[cert2date],[cert3date],[cert4date])) pvt
order by conID
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?