Unfortunately, I'm still on 2000. Also, the codes will not be unique...bummer.

I thought it was a good question. There's a wide range of members here with varying experience so what may be easy for some may not be for others. If...

Do a search on how to use dynamic sql and you should quickly find out how to do it 🙂

I'm not sure I have a better suggestion. I was just curious as to the origin. I actually thought the name was maybe a reference to the movie Mr &...

Ok...I get it now. Thanks!

Right...but why use "Mr or Mrs 500"?

Try using dynamic sql.

Maybe I would be a chef if not a DBA, although I really don't know much about cooking. I do love to eat though! I watch the Food Channel a...

Surprisingly, most of the important data on my home pc can be backed up to a flash drive. Although I am starting to build up a library of photos and...

One week seems a bit short. The problem is the person knows he/she is under the microscope and will make an extra effort to shine. Once the the trial period...

For me, comp time is better if I work extra hours in one chunk, say five hours on a Saturday. That usually translates into a half comp day during the...

Without more detail, i'll take a guess and say it's a collation issue. You may have to create a format file to properly translate the data. Do a search on...

I would add taking classes to expand your knowledge base is a good idea. It shows potential employers your willingness to learn and to take on new initiatives.

Good article. I would also add having an updated data dictionary helps too.

Fyi...for those needing a basic understanding of object databases (like me), this page is a good start:

http://www.service-architecture.com/object-oriented-databases/articles/index.html