Nice job, Ken.

That's a good example of a great technique. With SQL, you can run queries that generate the SQL you want to execute. Then all you have...

Hugo Kornelis (8/26/2015)

---

Interesting. My...

Sean's right. The first result of a Bing search found the page http://stackoverflow.com/questions/19708783/xampp-setup-to-use-name-instead-of-ip-address. It says to create an entry in your hosts file on the server, which makes...

Sean Lange (8/26/2015)

---

Interesting. As much I would be willing to help I think I...

Going off the post about this query at http://www.sqlservercentral.com/Forums/Topic1714385-391-1.aspx#bm1714502, this is something called Firebird SQL.

Brandie Tarvin (8/26/2015)

---

Oh, yeah. I use that one quite often. But I don't think that's what Grant...

SQLRNNR (8/25/2015)

---

TomThomson (8/25/2015)

---

Sean Lange (8/25/2015)

---

Ed Wagner (8/25/2015)

---

Alvin Ramard (8/25/2015)

---

Ed Wagner (8/25/2015)

---

I don't know if it's just me, but SSC has been having some blocks of time where it's very slow...

It doesn't work or you don't...

chindilog (8/25/2015)

---

I am using data tab in fishbowl inventory. Firebird sql. Database is connected to this software. Btw, labor isnt being used. I have removed it. Can you edit below...

Alvin Ramard (8/25/2015)

---

Ed Wagner (8/25/2015)

---

I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this...

Duplicate post. Direct replies to http://www.sqlservercentral.com/Forums/Topic1714385-391-1.aspx.

Duplicate post. Direct replies to http://www.sqlservercentral.com/Forums/Topic1714385-391-1.aspx.

Duplicate post. Direct replies to http://www.sqlservercentral.com/Forums/Topic1714385-391-1.aspx.

It looks like you need a GROUP BY clause, but I can't see your table definitions from your description. Please post DDL and some consumable data. If you...

Nap