Probably doesn't help that I haven't touched SQL in about 6 months, been up to my...

This looks perfect. However, my SQL ignorance forces me to ask how to read this from an XML file. I'm googling away at that question now, but not...

Thank you very much. I was getting so confused trying to figure out LEFT OUTER JOINS and RIGHT INNER JOINS... I was about to go JOIN a loony...

I have tried that, yes. However, what that gets me is all 189 FormNames for each ClassCode. Many of the ClassCodes have no assigned forms, so I'd like...

Sorry this took so long, but Thank You. This worked great!

Awsome, thanks Flo!

Thanks Flo,

Your ideas were actually much more detailed than I was thinking, but I can see the reason for doing it like you showed.

The one bottleneck I still have is...

Using Sum rather than Count worked for me. The way I have the table designed, I have one column that lists the filter number (PrimarAir) and the next column...

Well, I really have 2 problems here. First problem is getting the results of the SELECT DISTINCT statement correct. The OP code works great if each truck in...

Thanks for the advice guys, especially the ideas about bringing in a mentor, which I will look for at the local SQL server users group. Next meeting is in...

Thanks for the ideas guys.

Silverfox, yes I will indeed have my hands full, as I will be all of those things you listed at some point. They have a...