Switching/Redesign/Redevelopment is not a viable option as of now. I have to make this work somehow.

The COM is in-process (dll).

System RAM: 15.9 GB

Total Paging Size: 32000 MB

Max SQL Server Memory (in MB): 2147483647

Yes had viewed this. But we use SQL 2008, so I didn't think that was relevant. Didn't find any such fixes for 2008 / 2008R2.

Hi, I want to do the same thing from within a procedure.

Trying to do something like the following:

Declare @var_XML xml

:

:

:

:

Select @var_XML = (Select * From Tab_Name For XML...

Hi

What you actually want to do is something like "Select 10+20".

But the reason your last query fails is because you are trying something like "Select 10 + Select 20", which does...