shezi (7/27/2015)
This works great but when there is null value in any of the fields then the checking fails and keep inserting duplicate rows. Please advise
Did you try the solution that I posted? How does that work?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes