Ok, here's some code that will help. I take any given input date, determine it's fiscal year, and then generate a table of start and end dates for...

It appears your fiscal year is NOT a consistent number of days, even accounting for leap years. In the case of FY2009, the fiscal year is 371...

A previous poster provided the solution, but I think you missed an important piece of it. Here's a more detailed perspective:

1.) Create an empty spreadsheet as you would...

Assuming that you have a parameter in your stored procedure to receive the filename, something like what follows:

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE dbo.spWHATEVER_YOU_CALL_IT (

...

Example 1 in your "compromise solution" provides a result set consisting of RowID's 2, 9, & 10. Isn't RowID 5 supposed to be included?

Also, we STILL don't have...

Alec,

I'm pretty sure I've never suggested that "O-S = rubbish". It's always been the arguments for it that were, most of the time. There's certainly nothing...

It might be if not for the evidence I've seen that demonstrates that the vast bulk of arguments for O-S projects fell into the kinds of problem categories I've identified,...

That sounds a lot like "the cost of learning new things is zero", because by NOT acknowledging those costs, it's EASY to recommend new things. I'm certainly not...

I gave up on the solution I was working on, as I realized that the UPDATE statements I was using were unable to take into account the update it had...

To coin one of your phrases, YOWCH !!! ... at least in terms it getting bad enough to be meeting new people every day. Thank goodness it's not...

Anzio,

If you get the chance, could you test MY code against that same 1 million records? I'd love to know a) if it produces the same result, and...

Jeff,

Thanks for the feedback. I'll be referring back to your example code now rather than trying to remember it from scratch. There was a time (back...

UPDATE: just got lucky and generated a 13ms execution time on pattern 1. Subsequent attempts went right back to zero, despite changing to other patterns. I...

Dan,

Despite your explanation, I'm still not sure I completely understand the requirements, but I now have what I think is a solution. I'm not too sure on the...

While that's a nice idea that I prefer to agree with, it fails to account for the DEPTH of the stupidity I encountered, which simply cannot be "explained away" by...