Proof that the article rocks huh!!!

Read Jeff Moden's article here[/url]. It will walk you through the whole process. It is lengthy but incredibly informative.

DevNate (6/1/2011)

---

I'll use a smaller set of data. Say I have the a table of Cases with the following columns. Id, Date, Name. What I would like to do is...

Rich Yarger (6/1/2011)

---

So is there a better way to do this?

Example...

SELECT *

FROM Table

WHERE Column1 = @Column1

AND Column2 = @Column2 OR @Column2 IS NULL

It seems that if the WHERE statement is...

😉

John Mitchell-245523 (6/1/2011)

---

Sean Lange (5/31/2011)

---

Huh? You can use different collations in each and every database and column if you want. I have never heard that the reason they exist is...

I certainly wouldn't say that it is not worthy of being implemented. I was really just warning of the challenges you may face. My wife's company built a system with...

Here is what I mean about more legible. This is a rewrite of your query in #2

select 1, Amount, Amount, Type as AmountType

from InvoiceTotalAdditionalCosts itac

join Invoice i on itac.invoicekey...

Well we are not familiar with your requirements and we can't see over you shoulder so there really isn't a lot we can do. One comment I would make about...

No kidding. The scary level of this is off the chart. There are 4 nested while 1=1 loops. Which in turn declares 4 nested cursors. :w00t: This is a textbook...

Pretty sure this article will provide you with some useful information.

duplicate post. Please direct all replies here.

That may be correct but the question still remains...why would you need to open a text file with 13M rows. It would take weeks just to scroll to the bottom....

Duplicate post. Please direct replies here

Try this link for some help.