Please help how can i use this code to distribute colours evenly by sex
DECLARE @Employees TABLE
(
Name VARCHAR(10)
)
INSERT INTO @Employees (Name)
VALUES ('Sam'), ('John'), ('Jack'), ('April'), ('Sonny'), ('Jill'), ('Jane'),('sula'),('hawa'),('makumbi'),('martin'),('arker');
DECLARE @Colors TABLE
(
Name VARCHAR(10)
)
INSERT INTO @Colors (Name)
VALUES ('Red'), ('Green'), ('Blue');
DECLARE @ColorCount INT
SELECT @ColorCount = COUNT(*) FROM @Colors
;WITH Employees(SNumber, Name) AS
(
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS SNumber, Name
FROM @Employees
),
Colors(CNumber, Name) AS
(
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS CNumber, Name
FROM @Colors
)
SELECT E.Name, C.Name FROM Employees E
INNER JOIN Colors C ON
CASE
WHEN (E.SNumber % @ColorCount) = 0
THEN @ColorCount
ELSE E.SNumber % @ColorCount
END = C.CNUmber