Need help with be able to have variable counter for each row and count the criteria and have total criteria met in column.
DECLARE @Pcounter INT
SET @Pcounter =0
CASE WHEN A>.30 THEN @Pcounter = @Pcounter +1
WHEN B>.4 THEN @Pcounter = @Pcounter +1
ELSE @Pcounter = 0
FROM Table 1
Error is = , I"m not sure how to fix this for rewrite to correct.
It needs to count on each line of the table and criteria total for each line.