Many thanks, Roger.

Like many jobs, it's really simple if you have the right tool. In this case the right tool is the ROW_NUMBER() function. By partitioning on the...

I don't speak for anyone else at SSC, only myself.

But in my opinion you really should make the effort to cut-and-paste your question here at SSC.

That doesn't tell us much....

When I search on "business days" I find pages of entries. There may not be one that says precisely "Find Last Business Day Of...

Did looking at any of the forums or articles on business days answer that question for you?

Do you currently have a calendar table?

Thanks, Drew. I just took a look at that, and results are promising. If WITH CUBE doesn't get me all the way there, it's still...

igloo,

To put this in plain English, the date you want is the last businessday of the previous month.

Is that correct or not?

I've seen a lot of good discussions in here about business days calculations. Do a quick search on "Business Days" in the upper right hand corner and...

I said it was a start. I presumed you could parse the data once you had it in a table. I believe you can...

Some people spent most of that day in blissful ignorance.

I saw the new just before I was about to leave for work, and was stunned. Hours later...

Paul got 8000, I think.

Can someone point me to a good write up on IF... ELSE issues?

It can't happen to the first query because there is no WHERE clause. The second two queries are, or should be, mutually exclusive based on the IF logic....

Going.........

Going.....

Who wants post #8000?