steve-893342 (9/12/2010)

---

WayneS (9/12/2010)

---

steve-893342 (9/11/2010)

---

A variation using CROSS APPLY

This is a SQL 7/2000 forum... the cross apply won't work unless posted in the wrong forum.

shell_l_d (9/10/2010)

---

Wondering if there's a way to do a select query without a cursor (although easy enough to do, curious if can be done without one) to do something like this... here's a small scale sample of what I'm trying to do with a select query...

SQL Server 2000 (& 2005)

Yeh, but it says &2005 in the original post, right?