Frank:

I used to have problems like this too.  I kept scripts for all my views and stored procedures.  The script has a drop statement at the top followed by the...

Actually the fact that an SP uses the cached plan is one of the oft touted reasons to use SP's rather than dynamic SQL.  It save all that time compiling...

Glad to be of help.

Also look at http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx.  This is a what new but that would be new compared to 2000.

You can install 2005 on the same machine with 2000.  We have developers...

Right.  My point was that this is not cheating.  Not in and of itself.  What would be cheating is claiming that the work is yours when it is not.

What's cheating in our world?  We copy code from forums, articles, books, where ever.  I leave the original credit in the comments.

Two things that our boss considers cheating:  On Friday saying...

I'm currently involved in a project that is sort of unique.  It's for a multi-billion dollar company.  We threw out requirements, specs., milestones, etc.  I am in daily contact with...

Some of the projects that I'm involved in are considered warehouse projects.  Receiving, put away, moves, picking, packing, shipping, and order processing.  On those I say that it is important...

I guess that we are lucky.  We are vendors to our customers of hardware supplied by our partners.  While we do first line support if that does not get it...

We built some complex querries and the aliases were hard to remember as to what table was doing what.  Now our querries are even longer. 

Very good!

One problem though.  Your code to limit the password length does not work if I pass negative numbers.  When the specs are negative then they can't be more negative ten...

Good refresher.

Our company policy is to NOT use table aliases.  The VP in charge of development came down hard.  You have to use them in self joins though.

I get that too.  Mostly seen when this system has a link to an outside article.  I just thought that the editor had voted for the article somehow when the...

I remember reading all the Microsoft documents for the roll out of SQL 7.  Somewhere in that mess was a document that said that SQL server's reason for being was...

Good work, David.

I agree with the comments about IPv6 though.  Easily expanded to 6.  Our need is to validate IP's and to count the number of distinct rows over time...