Grant Fritchey (4/7/2008)

---

By the way, from what I can see, GetMatricule is going to force the query to function like a cursor, running this select statement for each row in...

Uh, huh... several different ways in the following URL along with some performance pit-falls to avoid...

http://www.sqlservercentral.com/articles/Test+Data/61572/

It would be an aggregate query to sum all the CDRs (Call Detail Records for Telephone Billing) for a about 120 thousand customers in a 4-5 million row table. ...

Hi Steve,

As with Matt, I always appreciate it when you jump in on one of...

Matt... thanks for the help. You're right, though... not a big fan of CLRs but could be convinced...

Thanks Matija Lah... I agree... that's why it's never...

Matt Miller (4/7/2008)

---

I know this is a REALLY ugly trick.... put "SP_" as the prefix. by doing that - it will go try to find the view in MASTER....

Like I said in my previous post, I don't think spreading a single header over 3 columns can be done. I...

I don't know if it can be done in reporting services... header "cells" would need to be "merged" as if on a spreadsheet. I'm sure it can't be done...

Sorry... I'm still not getting it and I want to make sure... you posted the following...

for item : A B

...

Sergiy (4/6/2008)

---

I once improved responce time of the query from 10 s to under 1 s just by replacing NOT IN with NOT EXISTS.

Don't remember exactly how many rows were...

What kind of bugs, Barry?

My most sincere apologies... the comment above does NOT apply to INDEXED VIEWs.

What matters is what you...

I have no...

Not to worry... Anyone who actually takes the time to get upset at either isn't someone you have to worry about offending because, although...