Filter data error-CodePudding

Table TMB has seven INT field to filter data from the table TMB, condition is: delete all the data of @ SZ0, @ SZ01 to @ SZ08 data in no more than 3, the following statement could not be completed, I don't know where is wrong, the great god, please give directions, thank you!

DECLARE @ SZ0 NVARCHAR (100)='1,2,3,4,5,6,7,8,9,10 - delete all
DECLARE @ SZ01 NVARCHAR (100)='11,12,13,14 - four number cannot exceed 3
DECLARE @ SZ02 NVARCHAR (100)='15,16,17,18,20 number cannot exceed 3-5
DECLARE @ SZ03 NVARCHAR (100)='16,17,18,21,22,23 number cannot exceed 3-6
DECLARE @ SZ04 NVARCHAR (100)='24,25,26,27,28,29,30 number cannot exceed 3-7
DECLARE @ SZ05 NVARCHAR (100)='31,32,33,34,35,36,37,38-8 number cannot exceed 3
DECLARE @ SZ06 NVARCHAR (100)='39,40,41,42,43,44,45,46,47 number cannot exceed 3-9
DECLARE @ SZ07 NVARCHAR (100)='48,49,50,51,52,53,54,55,56,57 number cannot exceed 3 -- 10
DECLARE @ SZ08 NVARCHAR (100)='58,59,60,61,62,63,64,65,66,67,68 number cannot exceed 3-11

SELECT a, b, c, d, e, f, g the FROM (
SELECT a.a, a., a.c, a. d., a.e, a.f, atul gawande --
, and COUNT (CASE WHEN tt. Id=0 THEN 1 ELSE NULL END) AS sz0
, and COUNT (CASE WHEN tt. Id=40 THEN 1 ELSE NULL END) AS sz01
, and COUNT (CASE WHEN tt. Id=40 THEN 1 ELSE NULL END) AS sz02
, and COUNT (CASE WHEN tt. Id=40 THEN 1 ELSE NULL END) AS sz03
, and COUNT (CASE WHEN tt. Id=40 THEN 1 ELSE NULL END) AS sz04
, and COUNT (CASE WHEN tt. Id=40 THEN 1 ELSE NULL END) AS sz05
, and COUNT (CASE WHEN tt. Id=40 THEN 1 ELSE NULL END) AS sz06
, and COUNT (CASE WHEN tt. Id=40 THEN 1 ELSE NULL END) AS sz07
, and COUNT (CASE WHEN tt. Id=40 THEN 1 ELSE NULL END) AS sz08
The FROM TMB AS a
CROSS the APPLY (VALUES (' a ', a), (" b ", b), (' c 'and c), (' d', d), (' e ', e), (' f ', f)), (' g 'and g)) c (t, v)
CROSS the APPLY (SELECT * FROM (VALUES

(0, @ SZ0),
(40, @ SZ01),
(40, @ SZ02),
(40, @ SZ03),
(40, @ SZ04),
(40, @ SZ05),
(40, @ SZ06),
(40, @ SZ07),
(40, @ SZ08) s (ID, sz) WHERE CHARINDEX (', '+ LTRIM (c.) +', ', ', '+ s.s z +', ') & gt; 0) tt
GROUP BY a.a, a., a.c, a. d., a.e, a.f, al-qeada
) AS the WHERE t

T.s z0=0 AND
Sz01 & lt; 4 AND
Sz02 & lt; 4 AND
Sz03 & lt; 4 AND
Sz04 & lt; 4 AND
Sz05 & lt; 4 AND
Sz06 & lt; 4 AND
Sz07 & lt; 4 AND
Sz08 & lt; 4