Thanks. However this is running in a batch job and not from query analyzer. Its running in a nightly process within a stored procedure.

Thanks again anyways.

Thanks Jeff.

Cheers lads.

Yeah I had thought of the print however I think you need

to convert everything to string i think in order to use

that. Was hoping it was some dboption which...

Cheers. I actually ended up doing it in SQL using the RANK( ) function which worked quite well.

However the above looks a good solution and I will end up using...

Unfortunately SQL is not the desired option. Normally I would prefer to go this

method however in this case it is not feasable.

Cheers anyways mate.

Thanks Michael. I have been doing some tests and the initial load of the cache seems to fail. Was developed in a testing environment which didnt have the volume of...