Here is code that will not work, but query works in SQL Server. I cannot figure this out.
The spelling is correct.
arep
I get this error:
Invalid object name 'SubrogationStep2'.
SqlCommand cmd = new SqlCommand();
cmd.Connection = HPDataBase.cn;
cmd.CommandText = @"DELETE SubrogationStep2
FROM SubrogationStep2 a
INNER JOIN
(SELECT FormNbr, ClaimType, AdmitDate
FROM SubrogationStep2
GROUP BY FormNbr, ClaimType, AdmitDate
HAVING (COUNT(*) > 1)) b
on b.FormNbr = a.FormNbr
and b.ClaimType = a.ClaimType
and b.AdmitDate = a.AdmitDate
WHERE a.Step2Seq not in
(SELECT MIN(Step2Seq) AS RecordToKeep
FROM SubrogationStep2
GROUP BY FormNbr, ClaimType, AdmitDate, FormNbr, ClaimType
HAVING (COUNT(*) > 1))";
cmd.CommandTimeout = 9000;
cmd.ExecuteNonQuery();
cmd.Dispose();