you've seen them before, just not named this way. In Official Microsoft training speak, they're called "Range-based non-EquiJoins" or "comparison-based non-EquiJoin". They're dangerous because they cause really high...

Jeff Moden (2/13/2008)

---

Sorry guys... didn't mean any offense... today's cold medicine still hasn't worn off and it came out all wrong 😛

I guess what I really wanna know from Stricknyn,...

Oh no denying it (as long as the context isn't lost that that was a tongue-in cheek comment). It's funny...all the...

Cumulative is nothing but a high-falutin' way to say "running total". cumulative = (running total by seqnum of incurred over months)

considering how small the data sounds like...

Jeff Moden (2/13/2008)

---

Chris,

Good one... Keep in mind that would be good for one row at a time (Rand is not random in a single query) and if the digit "0"...

Agreed - no reason it couldn't be run against the master, but since OP gave us a temp table, that's what I used.

Jeff Moden (2/13/2008)

---

Heh... I know how to solve all of this... put all data into a single Name/Value table... primary key will also be all foreign keys and covering indexes...

I'm thinking you just want to do an UPDATE, not an INSERT. INSERT adds new rows. You seem to be wanting to just add the values from...

dang it - missed what forum I was in.

ugh....No XML PATH in 2000.... So the syntax gets quite a bit longer.....

So - that particular example, no. Not entirely irretrievable,...

Cast them to char first with a format you like, then chop off what you don't want:

left(convert(char,PeriodstartDate,101),5)+' - '+left(convert(char,PeriodEndDate,101),5)

The articles I found yesterday as to hacking the registry were for 7.0, and had a note at the top stating you should use the "official" UI way in 2005....

Greg -

does your e-mail system support HTML? If so - there is a trick with XML that might work. The cure may be worse thant what you're...

Steve Jones - Editor (2/13/2008)

---

Ah, but I don't think that works. you still choose a default when you present the choice, meaning either clustered or nonclustered is selected. I guess...

I tried knocking off early the other day by using the "I've done 8 hours worth of work already today". Of course - it was noon, so my manager...

I noticed you didn't mention using the CASE statement to remove nulls from your second view. I suspect that is your issue. In other words - I wouldn't...