Thanks everyone for your responses, my intentions was not to offend anyone here. Just needed a direction in picking the right path. Thanks for sharing your knowledge & expertise....

I have spoke to some people who claim themselves to be SQL Guru's. Anyways, below is what I found...

1.Very few developers will be able to create a consistent stored procedure...

Thanks for the response...

I’VE have been advised to stay away from the stored procedures meaning the business logic should NOT be stored in stored procedures, except where really really necessary...