hi sergiy,

Thats right..

Those rows are practically identical...

So the point is we need to have some condition which will distinguish them from each other...

So i feel its quite impossible under such...

Hi,

There no row numbers associated.. i just wanted to make it clear..

through that example.

Thanks

Hi All,

Let me give my problem description in detail.

I use SQL server 2000.

I have a table 'TAB' with 3 coulumns 'Name','Age','Sex'

and there is no primary key.

I have multiple duplicate data...

Hi

Is there any other way to write the erraneous rows in the csv file to any text file in SQL SERVER 2000...?

Hi

Is there any other way to write the erraneous rows in the csv file to any text file in SQL SERVER 2000.

Thanks Gentlemen..!!! for all response

Hi Phillip,

Here we share same SA username and password and we donot have different usernames created for the SQL server.

Apparently, Every body who logins in uses the SAME username...

Hi Gogula,

Apparently i need to create a stored procedure which i will be calling from my C++ code.

First of all, i need to create a Excel sheet on the fly...