I've developed software for around 20 years, and now manage a somewhat complex mission critical ERP/CRM turnkey application.  My survival and any success I might be able to claim is...

Here's solution thanks to poster on my other post

SELECT ORG,

 ACCT,

 CLASS,

 PROD

 MIN(NOTE_TEXT) AS NOTE_TEXT

 MIN(HTML_TEXT) AS HTML_TEXT

FROM INPUT

GROUP BY

 ORG,

 ACCT,

 CLASS,

 PROD

Thanks ALL

Thanks a million; I guess the solution was just too simple for me to get

Thanks a million, this worked! I guess it was just too simple for me to get!

See sample data, first note, being the 'lowest value note' {in other words we don't care about which specific note text, what's important is writing a unique record where the PK...

Sample problem data

ORG  ACCT     CLASS  PROD    NOTE_TEXT       HTML_TEXT      

---- -------- ------ ------- --------------- ---------------

10   0000256  MEPG   DECORAT One of the Bay  <DIV>One of the

10   0000256  MEPG   DECORAT One of...

To all respondees, I've run the execution plan, statistics, etc., and have the answer I needed, no further responses needed.  Thank you all for your time and responses.

To clarify, the first uses subqueries, e.g., subtables and the second uses an in-line select statement in the select clause.

Essentially I'm getting lookup descriptions for values of fields in the 'main'...

I discovered the answer from another post, here's the solution:

DECLARE csr1 CURSOR FOR

SELECT CC025_ORG_CODE, CC025_EXT_ACCT_CODE, CC025_NOTE_CLASS, CC025_PROD_CODE, COUNT(*)

FROM #TEMP_SFCVB_WEB_NOTES -- Give your tablename having duplicate rows

GROUP BY CC025_ORG_CODE, CC025_EXT_ACCT_CODE, CC025_NOTE_CLASS,...