Query chANGE

Mar 18 2016 3:07 AM

i have a StoredProcedure and now i convert it to linq entity how to create this

INSERT INTO @checkDuplicateTable (Control_No)
SELECT r.[Control]
FROM @TableVar r INNER JOIN
(SELECT [Email Address],[OUT DATE]
FROM @TableVar
GROUP BY [Email Address],[OUT DATE]
HAVING count([Email Address])>1) a
ON r.[Email Address]=a.[Email Address] AND r.[OUT DATE]=a.[OUT DATE]