I'm using this code in a SQL Server Management Studio query.
Code: Select all
DECLARE @Counter INT, @MaxId INT,
@FileName [varchar](max)
SELECT @Counter = min(Id) , @MaxId = max(Id)
FROM #TempTable
WHILE(@Counter IS NOT NULL
AND @Counter <= @MaxId)
BEGIN
SELECT @FileName = FileName
FROM Data3 WHERE Id = @Counter
If (Select Count(*) from Data3 Where Filename = @FileName) > 1
Select * from Data3 Where Filename = @FileName
SET @Counter = @Counter + 1
END