Or perhaps INTERSECTing?

In some cases I have actually had to manually correct data that I have cut and pasted to excel. Just something that comes with the territory.

Awesome news! Congratulations!!

Steve Jones - SSC Editor (7/3/2012)

---

Lynn Pettis (7/3/2012)

---

Steve, I apologize for my latest rant to Mr Celko. I have tried to restrain myself since you asked me to, but...

Change the format on the cells. If this is in a specific column, you can do it to the whole column by highlighting the column, right click the column,...

Just trying to be thorough, are you sure you have configured the instances to accept remote connections?

AARRRGGGGGGGGGG!!!!!!!

If he isn't going to be helpful, why doesn't he just go AWAY!

Steve, I apologize for my latest rant to Mr Celko. I have tried to restrain myself since you asked me to, but I just had to respond today. ...

CELKO (7/3/2012)

---

The short answer is that good programmers do not use table valued functions. They are proprietary, screw up the optimizer and require disk access so they are slow.

Instead...

komal145 (7/3/2012)

---

Yes, I am trying to join the output of the function (where the output of function is independent of the data in the joining table) with table?

example

I...

And, if by interesting, you mean educational as well, then we have done our job in enlightening you. Thank you.

ScottPletcher (7/3/2012)

---

It's a pretty sure bet you have the wrong clustered...

Not really enough information to provide concrete advice. We can't see what you see, so it is difficult from your vague description to help you with the necessary joins...

SQLRNNR (7/3/2012)

---

Lynn Pettis (7/3/2012)

---

SQLRNNR (7/3/2012)

---

sqluser_8119 (7/3/2012)

---

Lynn Pettis (7/3/2012)

---

I'm...

SQLRNNR (7/3/2012)

---

sqluser_8119 (7/3/2012)

---

Lynn Pettis (7/3/2012)

---

I'm going to throw...