Thanks Gail for trying to help

I have sent you the quey plan, please let me know if you can see any issue or what is causing the high reads

one think...

Hi Gail

Unfortunately the query plan is very big to post, but here is what looks like the query:

Also please note that the query plan when I ran the query in...

A more efficient and clean way to do it is on client side

Bouarroudj Mohamed

http://www.sqldbtools.com

You can use this free tool

http://www.sqldbtools.com/Tools.aspx?ProductId=3

CONVERT works across all platforms & has more capabilities in SQL Server is also true

Here are some free tools

http://www.sqldbtools.com/Tools.aspx