delete old patient and their claims and procedures

[rajeshpareek]

Is there a SQL statement to delete patients, their procedures and their claims prior to say 09/01/2010. Much Thanks!

I entered patients from a new office with old office data. In the new office, want to remove the old office patient so that we get correct reports, patient list etc. OR Can I hide procedures and patients from the the list . Make them inactive ? THANKS!

[jordansparks]

No. Can you explain why on earth you would want to do such a thing? Open Dental never deletes patients or procedures; it just hides them.

[rajeshpareek]

THANKS DR SPARKS. I entered patients from a new office with old office data. In the new office, i want to remove the old office patient so that we get correct reports, production, patient list etc. OR Can I hide procedures and old office patients from the the list . Make them inactive ? THANKS!

[jordansparks]

No, you should have started with a fresh database.