I copied below code and it is giving me the xml parsing error, note that I am running it on SQL Server 2008 R2, Patch level 1753.

select CAST(

REPLACE(

REPLACE(XEventData.XEvent.value('(data/value)[1]', 'varchar(max)'),

'<victim-list>',...

I will prefer to have data in SQL Server and then use it in the join within SQL Server and that way it returns result more faster. Try this, create...

When execute a remote query, what SQL Server does is its bring down all the rows from the remote server to local server and then applies the filters. So it...

You can do it but in that case you have to make your query dynamic within the procedure...something like

declare @sql nvarchar(4000)

set @sql = 'SELECT * FROM...

OK...here is the potential problem. If you see in the View, there are many inner joins used. When you are going to insert row in any of the table used...

Can you share the definition of view? Index create statement alone doesn't help. We need to see columns in the view and then analyze insert statement...

Hi Veena,

You can try this one...it should work, you might have to use some other Aggregeate function in outer query if Sum alters the output....

select  sum(t.PQRCount), t.ProjectName, t.EmployeeName

FROM (

SELECT  COUNT(tbl_IB_Issue.CustomerIssueID) AS...

Can you share the indexed view script on the table1? Does table1 has any triggers?