Iwas Bornready (5/3/2016)

---

Andy Warren (5/3/2016)

---

Gary, the interesting part for me is that people ask a developer "what are you working on?" and they ask me "what do you do?". Both...

Turtle

I believe you'd be looking for the DENSE_RANK or RANK functions to do what you're trying to do with the Account ID's, keep in mind that will break if you...

Instead of processing all the records for each table then moving on to the next, can you process all the records in all the tables related to one customer?

Another option...

You need to convert the @numRows to a varchar before trying to append it to the string.

Also it looks like you're just using TOP <x> rows on the main table,...

Levitt

Iwas Bornready (4/28/2016)

---

David.Poole (4/28/2016)

---

The ability to remove an individual's records is a legal requirement in the UK. It is intended for data that is inaccurate or false.

We also have the...

Ed Wagner (4/27/2016)

---

djj (4/27/2016)

---

ThomasRushton (4/27/2016)

---

Ed Wagner (4/27/2016)

---

djj (4/27/2016)

---

Stuart Davies (4/27/2016)

---

crookj (4/26/2016)

---

Manic Star (4/26/2016)

---

Rain (felt good to...

In your join you have this,

pm_inv.meta_key='_invoice_no'

In your case statement in the select you have this,

pm_inv.meta_key = '_invoice_date'

Won't those be mutually exclusive?

Grant Fritchey (4/26/2016)

---

GilaMonster (4/26/2016)

---

Grant Fritchey (4/26/2016)

---

I do not recommend this because it will seriously negatively impact your startup time, but if you really want it to immediately use the memory...

What is the format of the send mail command you are using that worked successfully? It's also possible that your mail server is eating the emails from your Agent...

Grab

Ok so I hit my books last night and I am going to use row_number I think for the case part, although I am looking at reworking the query as...

Phil Parkin (4/14/2016)

---

ZZartin (4/14/2016)

---

Your order by isn't working because you are trying to sort by a alphanumeric field that doesn't sort in the order you want. Did you try...

Your order by isn't working because you are trying to sort by a alphanumeric field that doesn't sort in the order you want. Did you try this,

ORDER BY

case...