Sorry for the delay but I have sorted this using a store proc utilising dynamic sql. It wasnt that hard to be honest. Its been deployed in our prod env and working fine.