There are many ways to tackle this, and you say what tools do you have...but then you say it has to be a stored procedure. Why does it have to be a stored procedure?
John Rowan
======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden