Gary Varga (6/16/2014)

---

It's just like rounds at the bar: it is great when you don't bother count as some days you are surprised how little money you have left in...

I was once on a team where each of use would take turns getting a round of drinks in (zero cost i.e. free tea, coffee, water etc.). Some would get...

It depends on the size of the operation I suppose. If it's only a small place, then there may not be the budget for a cleaner but in larger...

@thomashohner

It's hugely frustrating when your results are questioned because they don't match what is expected or what somebody wants to see. I've recently been sending a lot of emails...

Express

thomashohner (6/13/2014)

---

Jeff you must have a crystal ball??! You just described yesterday for me. I actually had to say this in a email to one of our administrator's, "My reports...

It only takes a gentle poke to wake it.

Wild Turkey

I agree with you there Phil. I don't really see the point of enclosing the proc in the the BEGIN END block when it works just as well without....

Space

Thanks Chris, I'll definitely look that up and it's certainly something to bear in mind for the future. I think both my colleague and I learned something there. ...

ChrisM@Work (6/9/2014)

---

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE clause?...

ChrisM@Work (6/9/2014)

---

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE clause? If you...

ChrisM@Work (6/9/2014)

---

Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE clause? If you can answer...

dbalmf (6/9/2014)

---

I haven't tested this but i think your issue is with the ISNULL in the weird bit. When the name is NULL you set it to None. this does...