Tom Brown (5/6/2010)
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/
Yes, that would be one method that is better at producing this test data.:-)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events