I have played with this some more to fit into the desired results and requirements.

select t.field1, (

select count(*) line_count from #table2 where field2 > t.field2 group by field1

)

from #table1 t

You'll...

You're welcome.

GSquared (4/14/2010)

---

CirquedeSQLeil (4/14/2010)

---

WayneS (4/14/2010)

---

CirquedeSQLeil (4/14/2010)

---

WayneS (4/14/2010)

---

Lynn Pettis (4/14/2010)

---

And I did....

Here is a SQLMagazine article on the topic.

http://www.sqlmag.com/article/tsql3/nifty-ways-to-use-for-xml-path-concatenation.aspx

ychen 55059 (4/14/2010)

---

Thank you so much. That works beautifully.

I'm not familiar with XML. Could you point me to some additional resources so that I can understand...

WayneS (4/14/2010)

---

CirquedeSQLeil (4/14/2010)

---

WayneS (4/14/2010)

---

Lynn Pettis (4/14/2010)

---

And I did. Just...

Lynn Pettis (4/14/2010)

---

CirquedeSQLeil (4/14/2010)

---

Lynn,

On the topic of case consistency - please don't ever try Microsoft CRM. It will absolutely drive you bonkers. CRM requires objects be created through...

Alternatives to the Red Exclamation mark (which historically with MS has meant problems), use F5 or Alt-X.

WayneS (4/14/2010)

---

Lynn Pettis (4/14/2010)

---

And I did. Just waiting now...

Yes, size will have an impact on performance - slightly. The larger the database and tables, the more data that may need to be maintained. You should keep...

The Subquery will also throw an error

The multi-part identifier "#table1.field2" could not be bound.

On the line:

select field1, count(*) line_count from #table2 where field2 > #table1.field2 group by field1

Guess I was wrong. I interpreted the problem to be that debugging was taking too long and that you wanted to debug.

Glad you found your answer.

Lynn,

On the topic of case consistency - please don't ever try Microsoft CRM. It will absolutely drive you bonkers. CRM requires objects be created through the GUI. ...

I hadn't considered that. Makes sense. I should probably check my...

WayneS (4/14/2010)

---

In SSMS, are you pressing the Green Triangle, or the Red Exclamation Point?

The Green Triangle is to run in Debug mode, the Red Exclamation Point executes the query. You...