Nonsense. Normal Forms do not apply to result sets. Your own books are
full of SELECT statements which produce result sets not in normal
forms.

First, I don't really need to be grilled on terms here. Second I thought the
question was simple enough to not warant sample data and ddl, a point in the
right direction, so reading material would suffice. Third I know what 1NF
is. Let me tell you this, My db design is correct, this project is handles
by many developer, the client wants it this way, the SQL is writen at the
client end using Linq. Fourth Its not a mistake, its a request, next if you
have no help to offer, why don't you get off your high and mighty horse and
go and harras someone else.
O and BTW, if the kludge works, it works.

RObert

Some clients want you to assume the role of a gourmet SQL chef and will
gladly pay for it, while other clients expect nothing more than short order
kludges. At the end of the day, we all have to earn a living.

THanks. At least someone has the kindness to point me to some reading that
was extremely helpfull.

Robert