Modified GetLarrysReport Stored Procedure

I modified GetLarrysReport stored procedure to reference my Category table using CategoryID and added HazardID which was included into LarrysReport table. Category field is still in Larry's report. I will drop this column later. I want to be sure CategoryIDs match Category.

I added the column HazardID; it comes from Antoine's CSPV2 database concerning Contaminated Sites database. I will be linking to this database for all site specific data. I updated the HazardID to match his based on matching SiteDescriptions. It worked for some 270 records, I think. There are over 1700 records in my database which is still imcomplete, but it a working model.

When I get a better database going, I will incorporate all data in this program. It will still have to be edited, verified for accuracy, and some manually entered.