问使用Sql查询选择具有重复状态的记录

EN

        DECLARE @duplicate TABLE ( 
        trainerId INT,
        dt varchar(50)
        )

          INSERT INTO @duplicate SELECT TrainerId , [Date] from tbl GROUP BY TrainerId , Date HAVING (COUNT(*) > 1)
         SELECT * FROM @duplicate
         DECLARE @tempTable TABLE (
             trainerId INT,
             dt varchar(50),
             status int
          )
          INSERT INTO @tempTable   
          SELECT trainerId , [Date]  , STATUS = (SELECT COUNT(*) FROM @duplicate  where           trainerId = tbl.TrainerId and dt = tbl.Date) FROM tbl
          ![enter image description here][2]SELECT * ,  CASE [status] WHEN 0 THEN 'Available' ELSE 'Not Available' END FROM @tempTable