Laughing. This site would be slightly more difficult to use if everyone spoke their own language.

Laughing. Frank - depends on the company whether the DBA(s) are higher ranked than the developers.

We usually have the advantage of being the one or the few instead of...

I have been using ApexSQL Edit for several months.

It has some very handy additions that make writing sql easier (such as intellisense).

There are still times that I use...

Frank -

I understand. We are planning another addition to our family and I share the household duties. The wife works (sometimes longer hours than I do). I, too, have the...

Self-referentially short for PHP: Hypertext Preprocessor, an open source, server-side, HTML embedded scripting language used to create dynamic Web pages.

In an HTML document, PHP script (similar syntax to that...

Ian,

You are working with the database and are familar with the structure if you are writing Crystal and some SQL. Knowing how the data is structured could be considered the...

Ah, you're on "Honey Do" detail at home. I understand completely.

Laughing - there are times I am working with my European collegues and their day starts many (many) hours before mine and ends somewhere within 30 minutes of my first...

I guess the scary part is that he asked other DBA collegues and they did not know.

SSN would also limit the users to the US (unless we can convince our other employees in other countries of the beauty of having a SS card).

The good thing...

Nope. Stay with ANSI. It sounds as if the "helper" dbas used the defaults. There is no reason for you to be set up for UNICODE if you are strictly...

David -

You might try this as a start:

http://www.codeproject.com/database/mssqltutorial.asp

I googled a few others, but most of the links were 401.

I, too, have some C++ under my belt, but I've...

It should make no difference. SQL Server will traverse the index comparing the key to your criteria, to determine if the criteria exists, and then finds the data associated with...

Yes, PW is right. BREAK will exit the WHILE loop.

Bob -

It would be easier if we knew the table structure. It's difficult to see from the query where you return the OVERTIME and SICK, etc columns. The query you...