Your right. You don't want to group by SM. But your solution looks increadibly complex. Can't you break it up. It looks too complex to be...

It looks like this could be along the right lines. Are you suggesting that I run this code twice, so that I get the figures seperately for S and...

I wish to return two lists of rates (SM)s. The first list is specific to disease A and the second list is specific to disease B. These lists...

I'm now working with code that looks like: (but still getting error messages).

if exists (select 1 from INFORMATION_SCHEMA.tables where table_name = Temp_table_A) DROP TABLE Temp_table_A

CREATE TABLE [Temp_table_A] (

[Entry_key] [int]...

Thanks Matt for your code. One point. I'm not going to get the same result in the returns as your last point says. I'm going to get...

INSERT INTO #Temp_table_A

SELECT *

FROM Indicators_for_regions_Both I, Gov_regions_mining_score_TEMP G, Region_lookup R

WHERE RTRIM(I.Disease_type)...

No there isn't a need to use ntext. It just set that format when I copied it in.

SELECT *

FROM my_table

ORDER BY RAND()

I think that I need to look for a solution that uses the RAND...

This code does not give me a random order of numbers. It just gives me them in numerical order. Albeit 10,000 times.

Will the following give me the tally table that I need then?

--===== Create and populate the Tally table on the fly

SELECTTOP 10000 --equates to more than 30 years...

I don't really understand why you need a table with values up to at least 10,000. I want 1 to 354 to be reordered 10,000 times. Each time...

No the number can not be repeated