sdhanpaul (10/22/2012)

---

Im doing it in sql server 2005...management studio express

I used the nested subquery method in ms access before and it was slow.

You need to post ddl ( create tables scripts), sample data (insert statements) and desired output based on your sample data.

I have no idea what the ddl is.

I posted the sample results and the desired results...

I'm not sure what else I need to post...

Sorry if i seem to be hard headed...