This is a classic "pivot table" pattern.

There are many ways to solve this, and the replies so far are good solutions, but I think it's important to know...

The link that Phil posted is a good solution.

An alternative is to use a DOS script that loops through the files and uses DTSRun with the filename assigned...

I felt that this could be confusing for a beginner because the author was trying to optimize a simple query that couldn't be optimized.

Instead the author changed the...

I liked your explanation on your blog.

--Peter

That document misses some really big points and seems to be arguing about nothing. The author does not consider EDI standards or ASN.1 technology that came well before XML....

I meant that the stuff between the tags may have significant white space and _it_ should never be modified. Steve used the word "perhaps", implying that there may be...

I hope its not "perhaps"; it had better not modify the real content.

I'm not using 2005 yet as I won't see it in production for a year so why bother, but according to Denis Ruckebusch's blog your query should not work...

Points should be given for answer A or B. They both work.

If they don't someone should point out the flaw in our SQL Server configurations.

--Peter

This is acheivable through redundancy provided with clustering.

It's not the server hardware and OS that are important, it's the service that they provide. So the fact that...

I thought that today's article had an interesting tidbit that indicates that we've been asking to put more into the database, not less.

I would enjoy that. However, I won't be there. My current contract has me too busy, but being active in this conversation has been worth while

Yes.

We're seeing more and more distributed teams (some without shared culture if not language), developing in Internet time, contractors that come and go.

OOD and SOA emphasize encapsulation and...

That's a very open definition of the data. I think that there is a risk of some other application misusing the trade table if there aren't some higher level...

Mike,

How would you define the object in the database in this case; a trade?

A "trade" would have different properties and behaviors than an equity, or an option. It may...