Sorry...

Msg 8120, Level 16, State 1, Line 1

Column 'soh_shipmentnbrdata.Shiplist_Status' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Msg...

That works perfect. I was over thinking it. Thank you.

ChrisM@Work (3/28/2013)

---

kmundt (3/28/2013)

---

The status is always being set, because I require them in .NET to select something, but even when they...

The status is always being set, because I require them in .NET to select something, but even when they select both and it's 'B' it just selects the Closed fields...