Hi opc.three,

I am Thankful to you for your suggestion, But i would like to know if there is any other way to solve the query..i mean there is possibility that...

Hello,

I tried to use temp table instead of CTE but the performance got even bad after using temp table instead of CTE. I will explain the inner block logic

consider...

thank you everyone for your help...I will try and work with the suggestions given for my problem and will let you all know which solution helped me.

Thank you again

Yatish

we need this to be done on last day of every month.

Hello,

we need to insert more than 60,000 rows every months, with current numbers of users the data is 60,000 rows. it may increase in future also.

thank you

Yatish

Hello,

Please find the query code blow, I tried to divide the code block in two part and checked the execution

the first part I tried to collect all history data

...

I forgot to ask question about Hash match Join, you can check that in the execution plan it is taking time. how to improve performance for these Hash match joins?

Thanks jack for your help.

I did tried some changes to improve the performance and has able to bring down the time.

Still I need help from this forum to...

hell Jack

can you tell me by adding the OPTION(Maxdop 1) hint to query will it cost performance when multiple users accessing same data at same time from different location.

Thank you...

Hello,

I have modified the query to remove the CTE, Please find code below

SELECTOH1.TeamHistoryId,

OH1.TeamId,

OH1.Classid,

OH1.TeamIsLost ,

OH1.closedate,

OH1.TeamChangeDate,

(CASE OP.[action]

WHEN 'D' THEN 0

ELSE op.price

END

) AS price

INTO #teamsHistory...

Hello,

Please find the attachments.

thank you

can anyone please help me on this issue.

Thank you

Hello,

I have made few changes in the Query that i would like to share with you, It has help me to get few more improvements.

I have attached the new execution...

Hello Jack,

Thanks for your help, I tried adding the OPTION(Maxdop 1) hint to query. but it has not helped to improve the performance can suggest me any other ways...

Hello,

Thank You for your suggestions, it has really help me to improve the performance, thank you very much for your help

I did the changes and removed the Row_number() and...