Agreed!

Edward (7/2/2009)

---

Hi,

Can you create a join on a row but join it in such way that it acts like a distinct.

Ie. Convert tthis statement to a join

Select *...

Krasavita (7/2/2009)

---

Ok, Thank you I put for both 100 MB. I have for data 4,307 MB and for log 2MB. Do I keep it like this for now? Also I...

Molly Cary (7/2/2009)

---

When I looked at the server memory options this is what it's set too?

MIN is 0(mb)

MAX is set to 2147483647(mb)

other memory options

Index creation memory = 0

Min memory per...

Krasavita (7/2/2009)

---

Ok, Thank you I put for both 100 MB. I have for data 4,307 MB and for log 2MB. Do I keep it like this for now? Also I...

Thanks, but there may be better out there. I'm still reviewing an article that goes into...

Jay Tucker (7/2/2009)

---

OK, thanks for the tip about IFCodes. I checked out some of the posts on that subject, and will use in future. That CONVERT works with...

For that, we have given you a guideline. We suggested about...

GilaMonster (7/2/2009)

---

Lynn Pettis (7/2/2009)

---

Hey Jeff, you have a spare high-velocity pork chop launcher you can send me?? I think I'm going to lose my halo soon and I might...

Ian Scarlett (7/2/2009)

---

Lynn Pettis (7/1/2009)

---

Actually, I keep checking my calendar and I can't find ASAP. I can find Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday; but no ASAP....

But you keep asking the same questions. ...

You said you can't post the code for the UDF, but could you post code for the UDF with a faked process? It just has to show us how...

Hey Jeff, you have a spare high-velocity pork chop launcher you can send me?? I think I'm going to lose my halo soon and I might as well do...

Excuse me?? I have been helping, as have several others. We are trying to get you to think critically about the things...

I have taken the time to rewrite your stored procedure a bit and you may want to see if it returns the same data as yours. Not having anything...