But you seem to having one already in your query

(SELECT SUM(CASE WHEN SOA_TYPE IN ('Agent','Freight','Cost') or AC = '16208'THEN USD_AMOUNT ELSE 0 END) YourSum

FROM GL b WHERE...

Increase the Cost Threshold for Parallelism settings.

If that also does not help then you will have to find the offending queries that are causing parallelism which maybe due to missing...

The user will pass Start Date,End Date,No of...

This all looks so confusing..

You are trying to update column P of table_1 with column P of another copy of table_1 matched on table_1.link = selrow.link where selrow...

Yes that's right..

Quote strange.Can you post the entire query.

Is this SQL 2005 and above ?

EDIT: Whats the compatibility of the database ?

No need for dynamic sql.Just split the values ('Value1','Value2') and insert into a temp table

Value1

Value2

then Select * from YourTable where Id in (Select Id from Temp)

You will have to split the values coming in from the parameters.

Was the account name from domain deleted and recreated ?

SELECT DATEPART(MM,VISITINGDATE),SUM(COST) FROM yourtable

GROUP BY DATEPART(MM,VISITINGDATE)

If you are using sql server edition higher than 2005 you can simply convert it to date datatype and it will return just the datepart

select convert(date,'2010-09-23 13:02:54.000')

else you will have...

SELECT SUM(CASE WHEN fd.CalendarYear = '2013' THEN [Sales (LCY)]) 2013,

SUM(CASE WHEN fd.CalendarYear = '2014' THEN [Sales (LCY)])2014

FROM [$Cust_ Ledger Entry] cle

LEFT OUTER JOIN dw.dim.FiscalDate fd

ON fd.CalendarDate = cle.[Posting Date]

WHERE [Customer...

Instead of mixing everything in dynamic sql I would suggest put the desired records into a temporary table and then use only that temporary table in dynamic sql for pivoting.

Is the XML in proper format ? When I tried to assign it to a xml variable it threw an error

Declare @x xml='Your XML'

Select @x