Unfortunately, your example from several pages back conflicts with a statement by the OP that no range contains a duplicate, and your example starts out with one, unless he meant...

I'm still waiting for a complete and unambiguous description of the problem, as well as a good description of exactly what real-world problem the solution to the query problem is...

I'm not sure your data accurately reflects the real tables, but on the assumption that it does, then the following should help:

--===== Create the test tables

DECLARE @Company TABLE...

The text you've presented suggests you 1st delete a file and then want to rename it. If a file doesn't exist, how can you expect a rename...

If the website will serve multiple companies, I would think that there would need to be a table containing company-specific data, and that each company could then have it's own...

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...