Hello friends!!

I give you detail of my table and index

CREATE TABLE TEST_EMP (

SSN VARCHAR(9) NOT NULL,

CCODE VARCHAR(4) NOT NULL,

GRADE VARCHAR(2) NULL,

CONSTRAINT GRADE_SSN_CCODE_PK

PRIMARY KEY CLUSTERED (SSN, CCODE),

EMPID VARCHAR(5) NOT NULL,

EMPNAME VARCHAR(10))

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

NOW...

Hello friends!!!!!

The solution which Tony Webster has given that worked out!!!!

Thanks Tony!!!!

Shashank

Hello friends,

Thanks for that!!!!!!!!!!!!!!!!!!!!!!

shashank

Any way thanks for your help

shashank

Hello Remi,

I want each value only once in report

like as shown in my first forum..

if any body knows this please help me out

thanks in advance its urgent

shashank

Hello..

That was the case but that solved when i updated my sql statistics then that is showing correct results

thanks

regards

shashank

Hello,,

Actually this is very small data i was showing but in application we have very big data and client donnot want duplicates value to display like that we facing problem...

Hello,

My table structure like this

Id     FirstName    Country

10      John           A

20      Mack          A

30      Rock           A

40      Silk             B

40      Mann          C

Please Help Me Out!!!!!

Shashank

Hello Remi!

These all rows are only data in my table just i want to ignore duplicate rows rather i mean to say ignore  only duplicate values from my output!

Thanks In...

Hello friends,

 ..............Thanks for your reply,

 ...............but my question is how that comes,

 ...............i will change the owner,

 ...............but why and how that 'jdoe' comes in picture!!!!!!!!!!

 ................Is there any perticular command or login type...

Please use following link and do store proceture

http://www.sql-server-performance.com/rd_delete_duplicates.asp

Regards

shashank

hi Alex!!

i am giving little bit tension to u

pleasew tell me where i will get messege like below in DTS. I want to see flow of DTS please HELP...