declare @contador integer select @contador=1 DECLARE @myDocuments db_owner.DocumentsWithAutoIncrementIndexTable while @contador < 10000 begin INSERT INTO @myDocuments VALUES('The quick brown fox jumps over the lazy dog'); INSERT INTO @myDocuments VALUES('The brown dog walks through the brown forest'); INSERT INTO @myDocuments VALUES('Little red riding hood looks like a fox in her red dress'); select @contador= @contador+1 end DECLARE @myWords db_owner.DocumentsWithAutoIncrementIndexTable INSERT INTO @myWords(Content) SELECT word FROM dbo.mapper(@myDocuments, ' ') order by word asc select * from dbo.reducer(@myWords) order by wordcount desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)