Create view in SQL server for Binary duplicate check : Sqlserver

 

create   view vw_duplicate_face as

Select Photo, COUNT(EmployeeCode) as aa,

  min (EmployeeCode) AS EmployeeCode_min ,

  max (EmployeeCode) AS EmployeeCode_max

  from 

(

select [EmployeeCode], 

                     cast(cast([HDCPInfo] as varbinary(max)) 

                      as varchar(max)) 

  as Photo

from   [HWATT].[dbo].[KQZ_Employee]

)a

Group By Photo

Having COUNT(EmployeeCode)>1