Listing 1: Code That Creates T1 with One Column and Populates It with Sample Data
USE tempdb;
SET NOCOUNT ON;
GO
IF OBJECT_ID('T1') IS NOT NULL
  DROP TABLE T1;
GO
CREATE TABLE T1(c1 VARCHAR(10) NOT NULL);
GO
INSERT INTO T1(c1) VALUES('A');
INSERT INTO T1(c1) VALUES('A');
INSERT INTO T1(c1) VALUES('A');
INSERT INTO T1(c1) VALUES('A');
INSERT INTO T1(c1) VALUES('B');
INSERT INTO T1(c1) VALUES('B');
INSERT INTO T1(c1) VALUES('B');
INSERT INTO T1(c1) VALUES('B');
INSERT INTO T1(c1) VALUES('B');
INSERT INTO T1(c1) VALUES('C');
INSERT INTO T1(c1) VALUES('C');
INSERT INTO T1(c1) VALUES('C');