Whether sometimes you respond to a "situation" as best you can, even while aware that someone with different skills or experience may have offered a superior solution, I don't see...

Steve Jones - Editor (4/20/2009)

---

I think asking questions to better define a situation is a great response. As the interviewer, if you start answering, I start thinking "assumptions" and wondering...

I posted this reply to same question in the General discussion section (just now found this thread, so edited original to direct interested parties here).

--------------------------------------------

I'm not claiming...

I'm not claiming expertise here, but maybe my questions can help.

Why do you expect Row.EndOfRowset to be true? If the looping is outside the script and the script only...

You mention Reporting Services in your question. If that's what you're using, I think you may have better luck getting a response in the "Business Intelligence" forum.

Also,...

There's been lots of good discussion and feedback here. My initial thought on seeing the "what do you do in case of a major disaster" matched Alvin's -- lock...

Knowing your time zone (Pacific) is a good start. But of course you also will probably want to account for whether daylight saving time is in effect, making the...

bruce.trimpop (4/17/2009)

---

Hmm, my definition of "works fine" is it meets the requirements as put forth in the specification now and into the future. Are you saying your specs don't contain...

I think you'll get some argument on this. Cursors are easier to understand for someone...

Now I know I'm a true geek when I find myself thinking "the heck with 4000. ...

Am I so obsessed with big round numbers that I would post to The Thread just as an attempt to be number 3500?

I didn't think you were. Was just being (too?) cute with the way I...

My imaginary DVD player is stuck on repeat-play with "The Thread Zone". And I was so looking forward to watching "Thread Poets Society"....

RBarryYoung (4/16/2009)

---

dejan.kelemen (4/16/2009)

---

Tnx, this is a great solution, didn't come to mind when I was writing the code (it was more classic "hurry up" approach 🙂 ), although I did...

Dejan,

This is a classic example of how powerful the row_number() function can be. I coded this solution using a CTE out of personal preference, although I suppose that part...