Am I right in thinking there are a more efficient ways of creating the test data?

Such as:

WITH NORBAR AS (

SELECT N FROM dbo.Tally

WHERE N < 500 )

INSERT INTO QOTD (Title,EmailAddress,DateSubmitted,Age)

SELECT 'Mr','jsmith@email.com','24/03/2010',50

FROM NORBAR;

See Jeff's article on Tally table: http://www.sqlservercentral.com/articles/T-SQL/62867/