works a treat, thanks for your help

sorry, doesn't work as it does not aggregate or count instances per client in the joined select statement, all it does is returns the total number of records with null...

have done, cant see how to maintain its datetime format, if there is a way can you help

Craig

the purpose is to have a log file record of the steps parsed in a TSQL statement so that a record is kept of the process, this way there is a...