I am sorry. I googled this issue and got the forum--did not check the date and asked the question. I guess I will have to try to do...

Can you explain what exactly you did when you say

' a quick deletion and a quick disc repair and all is well '

I am reading this article:

Eliminating Duplicate Rows using The PARTITION BY clause

By Suresh Maganti, 2010/09/22

whihc is useful and will help me figure this out.

Thank you for all you help.

Yes, you are correct. I am trying to figure this thing out as I am getting the error-'The ranking function "ROW_NUMBER" must have an ORDER BY clause'

Yes, there is a field named DTS which has the date time stamp.

I am trying to delete all the duplicates. The duplicates are obtained using the query I listed earlier. The primary key for this table is PID and SQ...

Thank you for pointing out the forum etiquitte to me. I will keep that in mind from now on.

This is my problem.

I have a table that contains...

Only problem this is a table taht has all the student transcripts. There are several records for one ID. There are duplciates only when I inlucde all those...

delete from

tableA

where pid not in

( select pid, CN, mk, te, yr, st, cr, cc from

...

This seems to be nice. However, I ahve a question. I am trying to get SQL to create a tab delimited text file but I keep getting a...

I noticed if I use the stored procedure I have to map the suers one at a time. Even the statement

exec sp_change_users_login 'Auto_fix' needs parameters to be specified :w00t:...

Perry,

Do I run this stored proc in SQL 2008? Also do I use the migration wizard to bring all the mapping of the roles to the users and grant...

I am migrating from SQL Server 2000 to 2008. I used the Copy Database Wizard and copied the database over to the new server. We are doing side-by-side...

I tried to use the Copy Database Wizard to try and copy one database from SQL 2000 to SQL 2008 as part of migrating the database. I had some...

Now, does the sa account for SQL server 2000 and SQL server 2008 have the same password--I have them set up with different passwords?