Well done. I appreciate the effort required to put an article like this together let alone the coding to build the tool itself.

I know a guy that hangs on this...

Assuming this Excel file will not be so large that you cannot do this synchronously, reliably...another idea would be a design where the Excel file would be created by the...

In addition to what you have tried so far, it also helps if you provide the table definitions in the form of CREATE TABLE statements, sample data in the form...

You can definitely add a new method to an existing assembly. Altering the assembly will not automatically change the results of sys.assembly_modules. You also need to compile the complementary T-SQL object...

Happy to assist. Please help by posting the table definitions in the form of CREATE TABLE statements, sample data in the form of INSERT INTO statements, the expected results based...

@RandyAV, I read "Managing Time in Relational Databases" and am thoroughly enjoying the journey down the bi-temporal rabbit trail. I am driving a greenfield development effort at a large financial...

corey lawson (9/8/2016)

---

Good Friday was a "enterprise" business day off when I worked for company owned by Merrill Lynch, but that could also be because the NYSE is closed...

If you wanted to...

Love the topic. Calendar tables are quite useful, and are being considered more and more for use cases beyond the data warehouse.

speedcat (9/7/2016)

---

We have the same cost concerns. Our system may not have the processing or access concerns that some others do where performance or throughput become an issue.

We are...