Intro
At one time or another you've probably all had this situation where you've written yourself a procedure or function. Not a big one, just a couple, maybe 20 or 30 lines of code. And then, upon rereading it you think, 'nah, this is too big, this can be done better!'. You then think about it for a couple minutes, delete a section and replace it with a version that is three or four lines shorter. Confident that you've made a big improvement you continue. But was it really an improvement? Or better yet, weren't there better ways to optimize the code?

Idea
Ok, the idea is as follows. PM me with a procedure/function of your choice. Explain in a few lines what it's purpose is and why you think it can be done better or why you think the current solution is 'wrong'. If you already have a way to optimize it, please include that as well. Each week I'll then create a new thread with the suggested problem. After that, everyone can then suggest ways to optimize the code within that thread.

I want to keep this new event as simple as possible in the beginning and take it from there. Depending on the level of success I might change or add a few 'rules' or alter the release interval of new code problems.

In the meantime, I hope you'll find this a nice addition and I look forward to your entries.


To get to the first problem click here.