many thanks it is as I thought,

I think I would either clip them behind the ear or curl up into a little ball and start sobing

I have just created 3 temp tables with 7,000 row size giving a total of 21,000 row size. I then inner joined them and there was no warning.  Great!!!!

Hi David I will try point 3 seems that would be a good soultion failing that your right I will have goto point 1 and 2. Many thanks

The client is not flexable (NHS). They always make it very clear they have much better things than to talk to IT. No wonder so many IT projects fail in...

Thanks all ,I have trimed most of the sizes down from 250 to 50 where i could and now no warnings. There are a total of 90 columns in this table!!! It...

many thanks