Yeah, It's possible in SQL Server 2005
try this...
This query delete duplicate records in one shot....
delete from Table_Name where Column_Name in
(
select Column_Name from Table_Name
group...
Type: Posts; User: asthutc; Keyword(s):
Yeah, It's possible in SQL Server 2005
try this...
This query delete duplicate records in one shot....
delete from Table_Name where Column_Name in
(
select Column_Name from Table_Name
group...
Yeah, It's possible in SQL Server 2005
try this...
This query delete duplicate records in one shot....
delete from Table_Name where Column_Name in
(
select Column_Name from Table_Name
group...