SQL Select help

10 Nov 2005 5:05 PM

SteveInBeloit

I have a table that may have one to many rows. I need to alert the users if one of the columns of this table does not contain the same value for all rows. Say the column is 10 for the first row, 5 for the second, and 10 the the remaining 3 rows. I just need to tell them that there is a difference. I can't quite get a Select statement that will tell me this. Any thoughts? Thanks

10 Nov 2005 5:39 PM

Tibor Karaszi

Already answered. No need to post the same question several times.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"SteveInBeloit" <schand***@csiks-dot-net.no-spam.invalid> wrote in message
news:M7idnfxCzdFK4O7eRVn_vA@giganews.com...
>I have a table that may have one to many rows. I need to alert the
> users if one of the columns of this table does not contain the same
> value for all rows. Say the column is 10 for the first row, 5 for
> the second, and 10 the the remaining 3 rows. I just need to tell
> them that there is a difference.
> I can't quite get a Select statement that will tell me this.
>
> Any thoughts?
>
> Thanks
>