Hi All, 
               After google "Parameter Sniffing" i got the following solution and its working fine with following command "OPTION (OPTIMIZE FOR UNKNOWN)".

Thanks...

Thanks Admin

Hi Admin ,

Thanks for the script ,i am new for index .i am getting...

Two weeks before come across these, Good one...:-)

Ya I found Mr. its CTE Correct? 🙂

Hello Mr. i am eager to know how the "-- build an inline fast tally table" works if possible could u please Explain:-)

Good One Mr.mister.magoo

Did u check "@Borrower_id" data type in Table used inside the SP.

Please see the Query result attachment..........

Yes happycat59 I got the Same Error......:hehe:

🙂 Good One Steve 🙂

Good one.

Hi Steve Jones,

i have tried the...

Hi Kurt it is complex but nice one,i thing you used CTE for update process i am stater of CTE as of now i have seen only select queries but...

try to replace the following part in your coding i hope it will work for you .

SELECT @lStr = N'DECLARE @tblAmount TABLE(LegalEntity VARCHAR(10), Amount MONEY );INSERT INTO @tblAmount (LegalEntity, Amount)'+

...