PRSIM Spelling Errors

[mawgar]

Thank you to our partners in New Hampshire for finding a few of my spelling errors.  Below is a script that should correct these spelling errors for anyone who has these items.  If you do not have these items, running the script will return (0 row(s) affected) for each update.  If you have these items, you should get (1 row(s) affected) for each update.

USE STDPrism

GO

UPDATE Prism.Treatment

SET DS_Treatment = 'Doxycycline 100 mg Orally 2x/day for 14 Days'

WHERE DS_Treatment = 'Doxcycline 100 mg Orally 2x/day for 14 Days';

GO

UPDATE Prism.Report

SET DS_ReportDisplayName = 'Morbidity-Choose column (Area,Offender Age Group,County,User,Zip)/Grouping(Disease,Gender,Race)'

,   DS_ReportDesc = 'Morbidity-Choose column (Area,Offender Age Group,County,User,Zip)/Grouping(Disease,Gender,Race)'

WHERE DS_ReportName = 'HQMorbReportOffender';

GO