Jeff Moden (10/21/2007)

---

Heh... jury is still out on 2 times... it's starting to look a lot like the hardware or the installation may also make a huge difference. Davids...

There was a feeling that something is not right.

Now we have 2 point something times difference.

About the value I expected.

But it still should be under 2 times because there is...

Jeff Moden (10/21/2007)

---

I don't know about anyone else, but while a lousy 9 second difference on a lousy million rows doesn't seem like much, a batch process that may have...

Do you know that SQLOLEDB driver contains cursor...

Logic (you would...

So many words instead of just sayng "No".

David, I ccan tell you a secret.

Math is not about numbers at all.

Math uses numbers as an abstraction in an attempt to explain...

Then Jeff's script should work for you.

You just misled him a little bit, so code should be simplified:

SELECT * FROM #TestTable

WHERE (@dummy is null OR Title = @dummy)

Jeff Moden (10/19/2007)

---

Larger number of rows? Correlated aggragate sub-query on large number of rows? Dunno...

I've not had to "future-cast" in this manner before but every solution I've seen...

[Code]

SELECT

H.CustomerID

,H.SalesOrderID

,H.TotalDue

,H.PercentageOfTotal = H.TotalDue / T.Sum_TotalDue * 100.0

,H.DifferenceFromAverage = H.TotalDue - T.Avg_TotalDue

FROM Sales.SalesOrderHeader H

INNER JOIN (select CustomerID, Sum(TotalDue) Sum_TotalDue, Avg(TotalDue) Avg_TotalDue

...

Matt Miller (10/19/2007)

---

Data in my mind is like a project - it never survives contact with the real world. We as the DBA's and data modelers and data architects...

Trick is that outside the box is another...

David, for some reason I did not have any doubts about you and some other folks.

😉

SQL 2k5 made for programming tools users having no math background, just like you.

As I...

goodguy (10/19/2007)

---

Thanks, pal, but what I meant was how do I retrieve the temp table returned by the sproc into my vb code? How do I get a handle on...

Matt, do you think with Jeff's function fnDeleteNumbers (@String VARCHAR(8000)) from the post above code would be any longer?

And Jeff already committed performance test.

Result was not in favour of the...

Greg Snidow (10/19/2007)

---

I gues that makes sense. I have a very small database, so I have not really ever considered overhead costs of doing things. Got any suggestions...