Could you post an example? (DDL, sample data, expected results.)

Anyway, unless you know the XML Schema in advance you're pretty much in a world of trouble. Then again, why wouldn't...

I understand what you want to achieve, but you haven't answered any of my questions. It is of vital importance that you identify the relationship between the two sets. Sample...

What is the natural key for each company? IOW: how can you tell companies apart other than using the surrogate CompanyID key?

When you answer the question above you'll also know...

Have you considered using a calendar table? See this article for a few ideas:

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

For a better answer, please, describe your requirements in more detail (in business terms - tell us...

Please, give an example of the required output.

Thanks!

And I agree, Steve (& Co.) are doing a great job keeping the community active and productive.

Regarding this article:

http://www.sqlservercentral.com/articles/2926/

...none of the files are available, so it's not possible to know any DDL (especially how the tables are indexed).

While the duration of query execution is one...

I assume you have an alternative in mind that would perform better...?

What is the exact error message? Does your hardware meet the requirements?

https://msdn2.microsoft.com/en-us/library/ms143506.aspx

Several hundred thousand rows per table will not present much of a challenge to SQL Server 2005.

How frequently will the data be modified? What are the general use cases? Have...

Perhaps you should ask this in a Java-related newsgroup/forum.

When the mirror database is not available the mirroring session is suspended: the principal stops sending logs to the mirror, yet the processing on the principal continues. The unsent log...

Unless you find out how (if?) the data has been encrypted and either import the appropriate encryption objects into the database or decrypt the values using a client application, the...

The address to your web method should be in the form of:

http://server/endpoint_path?wsdl

More info in Books Online:

http://msdn2.microsoft.com/en-us/library/ms175476.aspx

What exactly do you mean by "aren't attached to a server"? Isn't the database engine installed on your machine?

The Express edition is in this regard no different from any other...