Well, the die has been cast pertaining to using XML to import the data.  So, though, I have already expressed concern about this, nothing can now be done.  XML schemas...

The idea of separate dbs per city (altho it is not actually a national/state/city app--but this analogy works very well for what I need to know) is what has been requested, but,...

Andrew:  1. not sure what an 'analysis server' is.  2. different days do not matter.  3. the concern over non-unique keys across dbs is a big one.  I don't want...

Per record in the same table, I need to replace every instance of a certain substring with a different value in an ntext column. Basically, I need to be...