Viewing 15 posts - 2,356 through 2,370 (of 4,080 total)
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 13, 2009 at 10:23 am
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 12, 2009 at 10:48 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 12, 2009 at 11:52 am
Did looking at any of the forums or articles on business days answer that question for you?
Do you currently have a calendar table?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 12, 2009 at 10:00 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 12, 2009 at 8:30 am
igloo,
To put this in plain English, the date you want is the last businessday of the previous month.
Is that correct or not?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 12, 2009 at 7:03 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 11, 2009 at 2:34 pm
I said it was a start. I presumed you could parse the data once you had it in a table. I believe you can...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 11, 2009 at 1:15 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 11, 2009 at 1:04 pm
Paul got 8000, I think.
Can someone point me to a good write up on IF... ELSE issues?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 11, 2009 at 8:38 am
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....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 11, 2009 at 8:29 am
Going.........
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 11, 2009 at 8:22 am
Going.....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 11, 2009 at 8:22 am
Who wants post #8000?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 11, 2009 at 8:22 am
Good point, Roy. Why don't you post it over in the forum itself, so the OP can see it and make it part of the discusson there, instead...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 11, 2009 at 8:05 am
Viewing 15 posts - 2,356 through 2,370 (of 4,080 total)