I think the answer is correct, but I have added a warning to the explanation so that people that might not read the discussion will see it.

Closing thread. Please post here: http://www.sqlservercentral.com/Forums/Topic703170-338-1.aspx

What do you want to get? What are you trying for?

Give some sample data, show what you want the output to be, include and error messages, etc.

I edited the code.

If you have a question, the title / description is not the place to put it.You also need to describe what issue you are having and what...

Good luck, Bob!

you can have my slot. I submitted one, but perhaps should have skipped it given all the submissions there are. I was thinking there might be less with...

Chris,

Sounds like you're in a good place and managing your career well. Good for you!

Interesting responses.

My wife says Dragon is great, but with ambient noise, and enough mistakes, it isn't good enough. There's also the fatigue factor, and it doesn't go nearly as...

If you reindex in a maintenance plan, which I think is a default for Sat night, it uses a lot of log space to rebuild the index. That is a...

Is the server overloaded when it times out? The disk I/O perhaps?

I'm not an SSAS person, but guessing here. I'd bet there is some other event on the server you...

You want, I think, to look at the CASE statement. Something like

select

case when rundate > runlog then myitem

else 'something else'

Or is rundate in Access?

If it is,...

If you look at this again, please be sure that you test, and test well, the impact. The advice from Microsoft is not to do it, unless they give you...

http://msdn.microsoft.com/en-us/library/ms173778.aspx

You can get the week number from the datepart() function. I think if you are showing a range of dates, get the week numbers from the first and last date,...

Excellent quote, Richard. And congrats for finding a place that works for you.

I'd disagree...