Thanks Gail, I will try this on Monday.

Jason even if i do it seperately and then join , then also SQL Server will have to use 3000 times XML path .

All, if there is an alternative to...

Thanks scott for your feedback. Appreciate it .

The clustered index on InformationOverride table cannnot be changed as the composite index on these 3 columns have unique data.

I am trying...

Hi Jason - Thanks for your feedback.

Please note this is a dummy data to understand what is the desired output.

the live code selects the data from different tables...

Yes It is giving the desired result set .

Basically the countryList, meetingList and Votes are the three columns which populate the 3 different drop down in application website.

This...

Thanks for reply Sean. I did read the article but after analyzing there are less changes of getting more than 10 comma seperated values. So spilt function might be...

Hi Sean, Can you please point out the function name to be used from Jeff Moden splitter attachment.

All, Can some one give me an alternative to these below queries

Query...

Thanks all for sharing your ideas / opinions.

I have attached few costly queries . The query number is same as the query number in execution plan.

The time statistics of...

Thanks Sean for the reply. Appreciate you taking time out to reply.

I understand its difficult to judge performance from what i have mentioned. But my company doesnt allow code to...