Welcome to the Lounge

Thanks for all, my challenge is the below code. If I am not using it then SP is taking 6 seconds to get data and after using it, taking more then 1 min
Please do you have any idea to optimize it

----------------------------------------------------
Update TMP1

Set DriverID = FDR.DriverID,
CompanyID = CDT.CompanyName
from @TempTable1 TMP1

   Inner Join (Select FaxID, CompanyID, LTrim(Replace(Stuff((Select  ', ' + ISNULL(Cast(FD1.DriverID as varchar(10)),'') From FaxId_Document_Relation FD1 Where FD1.FaxID = FD2.FaxID For XML PATH ('')),1,1,''),' ,','')) as DriverID

                    From FaxId_Document_Relation FD2
                      Where FaxID in (select FaxID from @TempTable1) 
                  Group By FaxID, CompanyID) as FDR ON TMP1.FaxID = FDR.FaxID
      --Inner Join CustomerDetails CDT on CDT.CompanyID = FDR.CompanyID --Anoop
	  Inner Join (select CompanyID, CompanyName from CustomerDetails) as CDT on CDT.CompanyID = FDR.CompanyID

Quote:

Start by reading the text at the top of the page and you will see in bright red letters that this isn't the place for technical queries. So if you want to make people happy, post this in the right place. Happy people give better help than annoyed ones do...

OriginalGriff wrote:

did you assume does not apply to you?

Orjan Westin wrote:

can contain NULL in the middle

Quote:

<nul> 00 Null Never affects the device. <nul> codes are always ignored wherever they appear in the character stream.