@thanks Jeff, will try this

Thanks Jeff. The automated process will be of great help ,in case you find it. 🙂

That works exactly.Thank you so much. I am on this issue for around 4 hours now. Next time I will come directly to the forums. 😀

@ray M

Thanks for a quick reply. I modified it to varchar(max) .It gave me a table output but doesn't have data in it!