I'd expect to see the items sorted in actual date order. At present, if I had articles from January and February of 2003, I believe I'd see them as...

MikeMcDonald's point was that SQL Server automatically inserts NULL into any column not specified in the INSERT statement. The exceptions are if no columns are specified (in which case...

I'm not sure that I'm completely following you. If I understand correctly:

• There are multiple companies
• Each company can have multiple regions
• Each region can have multiple areas
• Each area can have...

Maybe you don't have your file properties set correctly - make sure you see multiple rows in the preview.

I'd be inclined to do this with a trigger, normally. Any reason not to do that (like this only applies in a special case, or some such)?

Is bcp or Bulk Insert a requirement? This looks like precisely the sort of task that DTS is perfect for.

Possible explanation: It is common in many languages (including C++ and Perl) to "convert" integers into a true/false value by saying 0 = FALSE, anything else = TRUE. ...

Actually, the single table approach isn't truly a denormalized approach - data isn't repeated in it any more than it is repeated in the multi-table approach. As people have...

More points regarding the importance of flexibility:

There are problems with the single-table format and multiple rows of data. Your opitons are to hard-code which set of data...

Re-read the part about storing the previous and new values in the log table. If what I said would work, then you'd just store the updated value in the...

That's still an application-level solution - users with the right permission could still make changes directly through SQL. Even if our quester is the only person with such access,...

Also, using delete instead of truncate will preserve the last identity value.

Suggestion - can the code be manipulated to produce a page title for the browser window/tab?

Keep in mind that there is the possibility of incorrect results if the field following 'LIKE' includes wildcard characters. The inclusion of '_' or '%' might cause two unlike...

Although I got the right answer, one does have to make a couple of significant assumptions to get there:

1) The company uses the simplest form of its domain in...