stored proc with correct syntax
Corrected collate
BIGINT(20) patientid + Now runnable stored procedures

also removed extra new lines from sample files