>Cetin,
> I must respectfully disagree with you but the stored procedure vs ad hoc query debate has been going on for years now and it will for several more. I don't think we could possibly say anything for or against it that has already been said about 10 bazillion times. As with all things i guess it works out to what works best for you. In this i prefer the stored procedure approach but there is certianly room in the world for those of you refusing to convert to the true faith. =P

Yes always there is room for those of us refusing to convert to the true faith (which many see as ad hoc SQL queries - I didn't say a word about ad hoc SQL anyway. There is also OQL ad hoc queries for those of us on darkside anyways).
Cetin