John

Excellent code many thanks for your help.

John

Thanks for the advice.

The dynamic sql seems to be working OK as it is generating 0908 the problem I have is how to incorporate the dynamic sql into my query.

...

Madhivanan

Many thanks for the quick response.

When I run your code I get an error message "incorrect syntax near test_0908"

I will need to run this code each month as was...