Nick -

I don't know if it matters, but Paul's solution doesn't quite do what you specified, as it doesn't return data for the last date in the report range when...

Jeff Moden (1/8/2012)

Ok... I'm confused. People would almost always need the room for the night they checkin and never need a room for the night they checkout. Why...

While not exactly a comment on the outcome of this question, I do wonder whether people out there actually use variants. I never have, and also don't see the case...

Tao -

That's great, thanks. If only I can get rid of all the other stuff that is more important than everything else, then I'll be able to get to play...

Yes, still here, but I've had my head firmly in other issues lately. The code for the CLR sproc looks interesting - I'll give that a try as soon as...

Sorry for the delay in responding. Hectic week last week, but back with the program now...

OK. Perhaps my question was badly worded. I know how to get schema and data...

Thank you for your thoughts. I agree that something could be written to parse the output from your query (which is much the same as I had been experimenting with),...

cengland0 (1/26/2011)Imagine if you lost one drive in the first spanned set of drives and one drive in the second spanned set of drives. All your data is then...

I answered "the same", and was surprised to get it wrong.

But, having thought more, doesn't the answer depend on how many drives there are? I was assuming four drives, A,...

The question asks us to 'predict' the outcome, which implies you do it by inspection. But how is anyone supposed to know that 40358 is a relevant date serial?

Poorly constructed...

Well, at least I got something right - I had missed something!!

Thanks, Hugo 🙂

I chose #1 because all the others appeared to be referencing indexes, and there was nothing in the question that stated the table had an index.

Maybe I'm missing something here...?

I feel the need to enter the confessional - I got it right but for completely the wrong reason:Whistling: Where can I return my 2 points?

I, too, was confused between...

I had the same initial thought - it cannot RETURN a varchar, as return values are always int. So, that rules out one wrong 'un !!

Nice one, Steve! I spotted it about the time of "No more worrying....", and so was somewhat disappointed when I got to the spoiler at the end. Would have been...