Hmm, I notice some strange things here: you have a table named vwMatch_Base, which looks more like the name of a view. Also, it has no keys or indexes...

simon (1/28/2009)

---

Well, it certainly works...but I'm finding the performance is poor under large volumes. Indexing & optimization is a bit of dark art for me at this stage, could you...

I don't see anyway to convert from one to the other in your example ID's. They are definitely different numbers. This is either a handle that DMO created...

Nope, keep them all in. The...

Yes, this always happens on but the...

I only recommend movies that I enjoy watching. Take "No country For Old...

Perhaps I can find new ways to motivate them.

Jan Wagner (1/30/2009)

---

Hi Jonathan,

what I want to do is easy: I will have a staging table with parameters, and I have to run a stored procedure with each of them....

Grant Fritchey (1/29/2009)

---

Jack Corbett (1/29/2009)

---

All right, I've been essentially offline for 3 days and there are close to 100 posts on this thread AND IT has become self-aware!

My question is,...

Check out the SUM() aggregate function together with the GROUP BY clause of the SELECT statement.

In short, not only is this not reasonably possible, it is theoretically impossible.

Jeff Moden (1/28/2009)

---

I don't believe there's an easy way to do that, all though I could certainly be wrong. The fly in the ointment is what happens if a...

Oh and one "sleeper" if you can find it: "Kung-Fu Hustle", this under-appreciated gem is IMHO one of the best comedies ever made.

Think "Crouching Tiger, Hidden...

Family:

"Wall-E" Fantastic (5/5)

"Kung-fu Panda" Very Good (3.5/5)

"Bee Movie" ...

You know, I started a new project last week that keeps me off the forum during the week... Heh, I can't believe that I just spent my night catching...