• To SSC Veteran,

    Could you please read the full extent of my message in particular reference: "The majority of the SQL Server solutions are good and I got a lot of help in taking many of these ideas into my solution.", meaning for the benefit for some "good DBAs" I never use the codes published in this site strait out of the web page. Whatever strongly you feel about your point of you still should remain professional enough not even indirectly imply that who is good DBA and who is not. Among the qualities of a good DBA are accepting others' opinion and if disagree respond with professional courtesy. I don't remember that this site is for even remotely a tool to being personal. As I stated I "fiddled" with it and managed it to run. It it just happens too many too often. In the other day it happened the same with a piece of code (it was a function) which was supposed to return the date of the first day of the week. It in its original code had two bugs:

    1./ It returned consistently Tuesday as the first day of the week. I am aware of it that in some country Sunday is the first day of the new week in others is Monday. I newer heard of Tuesday being the first. If there such a calendar or country which uses Tuesday as the first day of the week please someone enlighten me about it.

    2./ When I entered as a parameter the date of Monday it returned the previous week's Tuesday the result even after fixing the above Tuesday issue. The bug was in the original code not my fix introduced it. I fixed this as well and I am happily using it in my project to develop a database application.

    And there was a period of a few weeks in early this year when unfortunately the majority of the published solutions and codes did not even work and found them so hopless after trying to fix them that I gave up to invest more effort in them. There were some SSIS solutions of which one of them the code and samples were published in an image format not web page text box and instead of the images on the page placeholders were displayed. SQLServerCentral.com is a trusted site in our web server firewall.

    And all the others who might directly or indirectly questioning my quality as DBA this is my reply. All my apology to the millions of genuinely professional DBAs and SQL Server developers who are like me registered members of SQLServerCentral.com community have to have to read this. Finally I did not change my opinion that crashing codes should not be published.

    Julien.