Try without Values and the brackets (), after the INSERT INTO line just have the select statement.

It would seem this may have been some memory leakage on the server and has been resolved by a reboot. However if anyone has any ideas of possibly resolving this...