BaldingLoopMan (1/19/2010)

---

i need one record returned per first, last, and zip.

The idea here is someone wants the data from this table. Well they want the records who have the most...

BaldingLoopMan (1/19/2010)

---

When adding the following three samples to your data, which one should be displayed (each one has values in two out of three columns)? Either, but just one...

Heh, my pleasure, it's not everyday you get to assist the Great Moden himself,

Have a nice one,

I just tried using SQL server 2005 Express SP2, (With the Express studio) and the option is there too. I find it pretty odd that you can't see this option,...

Jeff Moden (1/15/2010)

---

I'm working on an instance of SQL Server 2005 (Standard Edition) for a new company. I want to set the scripting options so that when I right...

My pleasure,

Thanks for the feedback.

I think this does what you need:

SELECT name ,

SCHEMA_NAME(Schema_ID) ,

Create_Date ,

...

Lynn Pettis (1/12/2010)

---

J-F Bergeron (1/12/2010)

---

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most...

J-F Bergeron (1/12/2010)

---

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most of the...

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most of the time), we...

Lynn Pettis (1/6/2010)

---

EDIT: HOLD ON, I think I have a problem!!!

2nd EDIT: Actually I don't, it was the data, it was getting truncated.

...

Going in a meeting, i'll be back in a few, if you have any other suggestions, i'd greatly appreciate!

Ninja's_RGR'us (1/6/2010)

---

Even if he can't add persisted columns... if I run a straight select and then a select with your computations it runs in the exact same time over 1M...

Not really, that is not an option, since the function is used across the system, everytime we need an output for cobol. It is in many tables, and sometimes the...

Have you tried creating the index as Gail mentioned? And after you do, can you post the new execution plan? It is far more helpful to see the plan then...