Thanks for the response and actually sorry for the confusion. I am new to the forum. But the whole issue is

Here is my query

select EmpName as 'emp/@ID',PositionName as...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[usp_V4_Report_AT_AttendeeBookingOverview_1June]

(

@Filters varchar(MAX),

@Company int,

@User int

)

AS

SET ARITHABORT ON

DECLARE @ReportFilters AS xml

...