Oooooo Good tip.

+1

Oh, hell. Are you saying I should actually read what I comment on.

I'm so caught red-handed right now.:hehe:

Nice article. Good points. And all that Jazz.

But - I was stunned by the use of underscores as source aliases.

cross apply (something) as _

cross apply (somethingelse) as _1

That...

+1 for this editorial.

Yes, that formula makes a lot more sense now. Will they let you send updates to the code, or do they lock it down?

Would love to see this get...

Help a nublet brother out. 😀

I failed to see where and how ada comes up with the correct formula to use when you simply used the words "model.formula" as the...

This article really hit a chord with me. I've also stumbled into databases, first through plsql briefly, before stumbling into access and finally landing on sql server, I too must...

I see the "myth" is busted for Full model.

Is it still un-busted for the other models?

Deliver('Book') = Good * 4

And now for Matrix Multiplication with bonus Window Functions. 😀

if object_id('tempdb..#a') is not null begin drop table tempdb..#a end ;

create table #a (

...

THIS! One of the best quick tips ever posted here. 🙂

Funnily, I remember reading this article when it was first published! 😛 Its truth is still spot on today, as it was then. Nothing has changed in the world of...

Correct, I second that. The first script example under the .WRITE section is a duplicate of...

sang-lee (12/2/2009)

---

I haven't looked at the source code, but will this be limited to the 65K rows for excel or will it allow the 1 Million row limit for Excel...

This is not another post looking for the missing download. That would be rude.