Jeff,

What I really need is a solution that deletes the duplicate records. As I explained the dups are occurring because of uniqueness in the rows caused by any number...

Works perfectly. Jason, bitbucket, Lynn thanks for all of your inputs - really appreciated.

costa

Jason,

Thanks for your assistance. I get an error message as below:

WITH dedupeCTE (ID, COUNT(*) AS DuplicateCount)

AS

(

SELECT ID, DuplicateCount,

ROW_NUMBER() OVER(PARTITION BY ID, DuplicateCount ORDER BY ID) AS DuplicateCount

FROM DupsDueToUniqueRows

)

DELETE

FROM dedupeCTE

WHERE DuplicateCount...

absolutely a front end issue but it can't be addressed asap. we just have to resolve it on the extract.

for starters the front end is a mess and doesn't do a check but also I have spot checked a few.

Thanks Gail and GSquared. You have answered my question. Your help is appreciated.

costa

That is correct but I am trying to advoid using distinct count query. My hope is that sql server has it in system table / views that I can just...

Jeff, Vicky, Carolyn, Rudy and Manu thanks for your input; it is very much appreciated.

set columnname = replace(replace(substring(columnname,1,datalength(columnname)), char(13),''), char(10), ' ') works however I am still having issues for...

I tried and it doesnt work. The extract still has inbedded carriage returns like before with attempts in some records to remove it.

Thanks

Jeff,

The attempt is to just handle the text or nvarchar datatype.

Thanks,

Jeff,

IT WORKS!!!!!! Thanks a million for your assistance; it is very much appreciated. Also my apology for giving Lutz credit for your articles and I want you to know...

Lutz,

My apology for posting in the wrong forum and thanks for pointing that out...rookie mistake :-). Also thanks for pointing out that I credited you for Jeff's article; really appreciated...

Gah,

Great point and I raised this in a meeting this afternoon. Everyone just wants a solution at this point.

Thanks,

I certainly do. The dataset here is an example ofcourse however it closely maps to the actual:

1) There are only 3 products types

2) The business reasoning I guess is to...

Jeff,

Thanks for pointing that out. The layout should look like:

cusid name product1 status ...