If I understood you correctly, your problem isn't really how to group by a date: GROUP BY [ASSIGNED] takes care of that. I'm sure you...

If you want a count of all the combinations, just multiply the count of distinct table 1 values times the count of distinct table 2 values.

declare @table1 table (value1 char(1))

declare...

I stand corrected. Thanks, guys.

You can do the conversions on the fly in a single query by using expressions in your joins and where clauses. It may be slower than joins...

Google "NickNames Database" and you will find a number of sources, for common English names. But there is no universal list of ALL first names. ...

t-boned

Stefan Krzywicki (6/17/2013)

---

SQLRNNR (6/17/2013)

---

Stefan Krzywicki (6/14/2013)

---

wolfkillj (6/14/2013)

---

Chad Crawford (6/14/2013)

---

wolfkillj (6/14/2013)

---

The Dixie Flatline (6/14/2013)

---

Brandie Tarvin (6/14/2013)

---

jcrawf02 (6/14/2013)

---

SQLRNNR (6/13/2013)

---

Chad Crawford (6/13/2013)

---

The Dixie Flatline (6/13/2013)

---

I will explain...

No, to explain will take...

parallelism

Take care, Lynn. Come back safely.

Brandie Tarvin (6/14/2013)

---

jcrawf02 (6/14/2013)

---

SQLRNNR (6/13/2013)

---

Chad Crawford (6/13/2013)

---

The Dixie Flatline (6/13/2013)

---

I will explain...

No, to explain will take too long. I will sum up.

The Doctor is on first.

The enemy's...

Hats for bats....

Keep bats warm.

Get many hits.

Gracias

Thanks for that link, Chad! My wife has wanted one of those shirts forever.

Edit: +13 for getting that reference.

Unquestionably.

When did The Doctor...

I will explain...

No, to explain will take too long. I will sum up.

The Doctor is on first.

The enemy's gate is down.