SELECT
[blue] as col1,[red] as col2,[white] as col3
FROM
(
SELECT b . Size , a . Color , a . Color + b . Size as
c
FROM tblB as
b
CROSS JOIN tblA AS
a
)
AS
p
PIVOT
(
max ( c
)
FOR
color
IN ( [blue] , [red] , [white]
)
)
as
pvt
DELETE
FROM dbo.tbLab
WHERE
ID>10
DECLARE
@i int=0;
WHILE
(@i<1000)
BEGIN
SET
@i=@i+1;
INSERT
dbo.tbLab VALUES(@i+10,CHAR(CONVERT(INT,Ceiling(RAND()*100))%26+97)+CHAR(CONVERT(INT,Ceiling(RAND()*100))%26+97)+CHAR(CONVERT(INT,Ceiling(RAND()*100))%26+97)+CHAR(CONVERT(INT,Ceiling(RAND()*100))%26+97))
END
SELECT
Name
FROM
dbo.tbLab
WHERE
Name Like 'ang%'
GO