Delete Dublicate Records
To remove Dublicate Records from table, a very simple query
Delete T1
From EOI T1, EOI T2
Where T1.EoiNo = T2.EoiNo
And T1.ID > T2.ID
enjoy!!!!
11 Wednesday Aug 2010
Posted SQL Server
inDelete Dublicate Records
To remove Dublicate Records from table, a very simple query
Delete T1
From EOI T1, EOI T2
Where T1.EoiNo = T2.EoiNo
And T1.ID > T2.ID
enjoy!!!!