Distinct Row based on description count

[eighthman11]

Hello everyone.

Hope someone can help. I have a table with two columns Material
Number and Material Description. Sample data below:

Material# Description
10000 This is item 10000
10000

[Roy Harvey (SQL Server MVP)]

Re: Distinct Row based on description count

On Tue, 29 Jul 2008 13:04:32 -0700 (PDT), eighthman11
<rdshultz@noote r.comwrote:

>Hello everyone.
>
>Hope someone can help. I have a table with two columns Material
>Number and Material Description. Sample data below:
>
>Material# Description
>10000 This is item 10000
>10000

I see that you started to try to ask a question in the Subject, but it
is not at all clear (to me at least) what you are asking for. Perhaps
you can be a bit more specific.

Roy Harvey
Beacon Falls, CT

[Plamen Ratchev]

Re: Distinct Row based on description count

It is not clear what you need, but maybe this:

SELECT material_nbr, MAX(description ) AS material_descri ption
FROM Materials
GROUP BY material_nbr;


Plamen Ratchev

http://www.SQLStudio.com

[--CELKO--]

Re: Distinct Row based on description count

Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. If you know how, follow ISO-11179 data element naming
conventions and formatting rules. Sample data is also a good idea,
along with clear specifications. It is very hard to debug code when
you do not let us see it.

What you did post used #, which will screw up your data dictionary
when you try to put that data element name on the Internet,
"descriptio n" of what? etc.

Then you never finished asking a question in the posting. This is too
vague to be considered seriously.

If you want to learn how to ask a question on a Newsgroup, look at:

http://www.catb.org/~esr/faqs/smart-questions.html

[Erland Sommarskog]

Re: Distinct Row based on description count

eighthman11 (rdshultz@noote r.com) writes:

Hope someone can help. I have a table with two columns Material
Number and Material Description. Sample data below:
>
Material# Description
10000 This is item 10000
10000

Looks like you pressed the Send button too quickly?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx