Which means nothing, I'm definitely not an expert, just trying to learn 😉

opc.three (5/24/2011)

---

...I am confident you already knew this...

webrunner (5/24/2011)

---

Not so easy for me -- I got it wrong by picking 13. I thought that despite reseeding the INSERT would add one to the current max ID in...

opc.three (5/24/2011)

---

Sure thing jcrawf02. As a side note, I would not have posted at all because the poster would have caught the IN/NOT IN logic nugget, however when there is...

opc.three (5/23/2011)

---

...same results but a little more concise:

SELECT INDACCOUNTNUMBER ,

TOTALPYMTAMT ,

NETPAID ,

...

...Brain exploding.....can't ..think...anymore...!!!!!

Gah!

*Achoo!!!

There, all better.

Thanks Paul!

LutzM (5/24/2011)

---

GilaMonster (5/23/2011)

---

LutzM (5/23/2011)

---

Regarding the specific situation: it might be better for the person in question to officially ask for support. Try to deal with the situation "undercover" would just...

SQLRNNR (5/23/2011)

---

Jim Murphy (5/23/2011)

---

Jack Corbett (5/23/2011)

---

LutzM (5/23/2011)

---

GilaMonster (5/23/2011)

---

Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean...

you might also want to convert it to XML, then you can actually expand it and look at the elements (it'll come back as a link, click on it, and...

Try wrapping your column in ISNULL() or COALESCE()

example:

SELECT INDACCOUNTNUMBER, TOTALPYMTAMT, NETPAID, PAIDDATE, ACCOUNT_NAME

FROM dbo.Audit2010$

WHERE ISNULL(ACCOUNT_NAME,'') IN ('Community Impact Fund','Health', 'Income', 'Education','Community Relief Fund')

I don't know the exact reason, but my guess it has to do with the clustered index being in the reverse order of the columns as listed in your SELECT....

Not a fan of roses, Craig?

SQLRNNR (5/19/2011)

---

That and the liquor displayed on your...

SQLRNNR (5/19/2011)

---

I like your new avatar. I was thinking of doing...

hahahahaha....sorry you put so much time into that one, but that's pretty funny...

Bill Cosby told Noah to do that? Man, was...