Wow. The new article is like 3x as long as the last one. Good stuff.

My fault, I checked it again before I posted that, but I didn't fully read it, I just saw that it was...

TheSQLGuru (11/27/2009)

---

Just asking is all, since there are quite a few of them and you are (to me) a new entity here. 🙂 I do seem to recall most...

You can make non-permanent number tables using CTE's. Here's one example...

Yessir. Why, does one seem missing to you?

I think you may have adequately conveyed the gist of what you want to do, however, it'd be easier for many of us to understand if you would work up...

Getting closer. Did you read the article I mentioned?

Put the data/table structure in a format I can do something with and include the where clauses for both...

I don't understand the question. Please see the post in my signature on how to provide sample data to get a better idea of how to ask a question...

Yes.

(And if you want a better answer, ask a more specific question.)

Heh, thanks. You know me, I'm always ready to jump on any chance to use that quirky update! 😉

jb-1079038 (11/25/2009)

---

Hi Folks,

I've introcuded a new environment variable to my clients, lets call it %LOGONTIME% with a value that changes and appends each time a user logs on. ...

Does a fill factor of 80 really explain that discrepancy though? The way I understood it, that should fill the pages 80% full, leaving unused space equal to 25%...

You're missing the else's in the case statements that point to the rownumbers in the left joins. You can actually copy/paste/run that in SSMS to see what it does(although...

Create a clustered index on (model, date1) ?

That alone would likely have a massive performance impact.

[fEDIT] Irrelevant after I edited the code.