--如何体现所谓的上一期?
case when
charindex(','+rtrim(上一期blue)+',' ,
','+rtrim(r1)+','+rtrim(r2)+','+...+rtrim(r6)+',' ) >0
then 1
else 0 end as repeat
case when
charindex(','+rtrim(上一期blue)+',' ,
','+rtrim(r1)+','+rtrim(r2)+','+...+rtrim(r6)+',' ) >0
then 1
else 0 end as repeat
(SELECT ROW_NUMBER() OVER(ORDER BY GETDATE()) AS RID ,*
FROM LI )SELECT
T.*,
(CASE WHEN (S.BLUE = T.R1 OR S.BLUE = T.R2 OR S.BLUE = T.R3
OR S.BLUE = T.R4 OR S.BLUE = T.R5
OR S.BLUE = T.R6) THEN 1
ELSE 0 END) AS REPEAT
FROM TLI T,TLI S
WHERE T.ID = S.ID + 1
select * ,case when exists(select 1 from tb where r1+1=a.r1 and blue=a.blue) then 1 else 0 end from tb a[/code]