😀 Hi Steve, I would like to thank you for a wonderful article. Might I say that when we learn from these discussions, is it not our duty to give...

gwardell (3/21/2008)

I found it just plain stupid that a company would release software that would not run as a regular user, requiring it to be an administrator account just to...

Hi Jeff, and I thought you were an American. Americans only eats meatloaf or not?:hehe:

:P:P Excellent article Jeff, I have a question for you though. Is there a FROM clause for the DELETE statement as well and how can I code that?:w00t:

Hi David,

:P:P Thanks for a very nice article. I am still a bit new on SQL 2005 so I had a bit of difficulty to understand the code. I come...

I dunno 'bout you Pete but I normally put a connection to my database in my code (VB etc.) so the program will know where to look for the stored...

Cliff,

Once again I have to say that I inherited this database. I don't know if I would have done differently if I had done so myself. After all, the Master...

Hi Steve,

If I could just quickly comment on your examples of code writing. I would do it as follows

SELECT a.bankid, a.datum, a.instruction, a.amount, a.description,

...

Ok, I'll try to answer all the questions/comments at once.

1. Lynn, I would create the merge numbers in a way that I would not have to have another table. I...

Hi Tony,

When it comes to naming conventions and writing standards I can be quite a perfectionist. When I cames to tables I will use PascalCase names like CustomerName, CustomerId...

Matt, congrats with the gift cert. May ther be many more!;);)

Hi Jeff, Thanks for your input. I want to however say to you that I also do not delete data from a permanent table. This Journals table is a working...

Shoot, I hadn't expect such a reply to my Bankstatement comment. Guys, I have to apologize profusely to the people the created the bank statement table and to you. I...

Thanks Jack,

I have been searching but clearly not enough. Thanks a span, you helped me save a lot of work.:D:D:D:D:P:P

😎 I have to agree that identity columns are indeed evil! Especially when someone before you created a database and now you sit with the problems. Example: I have a...