Yes, using x64 SQL Server you really need to set the maximum memory. If you don't, SQL Server will eventually take it all and starve the OS. Depending...

Gianluca Sartori (4/16/2010)

---

Luke L (4/16/2010)

---

So is there a good way to search within a thread specific thread? Looking for information from earlier in this thread. Someone suggested using...

Actually, not really. Please take the time to read the article I refered you to earlier. You need to provide us with more information if you really want...

To begin with, this is really a business decision first. Once you have the requirements for doing the invoicing, then it should become easier to determine what needs to...

For the best help, please read the first article I reference below in my signature block. Follow the instructions regarding what and how you should post table definitions, sample...

GabyYYZ (4/16/2010)

---

CirquedeSQLeil (4/16/2010)

---

GabyYYZ (4/16/2010)

---

Michael Earl-395764 (11/18/2008)

---

Is it me, or are the posted questions getting worse these days?

I just read a post by someone apparently in charge of something who was...

Not too happy with how you format your code, and your FROM clauses would take too long to reformat in a manner that would make sense to me.

Using your code,...

You may also want to compare the actual execution plans between the two queries.

If possible, could you post those here if you still have problems?

Hard to say. Can you recreate the problem in a test environment that you could share the code with us? I'd rather not have you post the real...

My concern with the intermediate table, what happens the first time a customer orders more than 8 products? If you only have 8 products, what happens when you add...

Give this code a test spin:

SELECT DISTINCT

ot.BusinessKey,

ot.Name,

ot.OrderNo,

ot.OrderDate,

STUFF(( SELECT

...

Thanks, I just posted it. Oh well, time to go to a meeting.

Have you looked up CHECKSUM in BOL (Books Online)? If not, try this.

Skipped A class? How about the entire course!

Actually, anything we tell you is simply a shot in the dark. We have no idea what you are trying to do, or what type of data is being...