LISTING 4: Code That Creates the Test Data to Count
 the Number of Times a String Appears in Another String

DECLARE @NumLoops int, @CurrLoop int
SET @CurrLoop = 1
SET @NumLoops = 999

SELECT * INTO titles FROM pubs..titles
SELECT * INTO titles_big FROM pubs..titles

BEGIN TRAN
WHILE @CurrLoop <= @NumLoops
BEGIN
	INSERT INTO titles_big
	SELECT * FROM pubs..titles

	SET @CurrLoop = @CurrLoop + 1
	
END
COMMIT TRAN