yes its working now

thank u 🙂

my temp table name is #TestTable

create TABLE #TestTable (FunctionalityID int, PageCode nvarchar(250), NameE nvarchar(250), ControlType nvarchar(250), ControlName nvarchar(250))

INSERT INTO #TestTable(FunctionalityID , PageCode , NameE , ControlType , ControlName )

(SELECT execute...

i am but really i need help 🙁

Thanks for response

The table RecordedCalls contains 1000,000,000 Records, the other tables used in the join will not contain more than 15 Records for each one.

The table lookups contains like 200...

anyone!!

-the condition date, Duration and another conditions based on User criteria i got it from executing another SP inside my SP then i concat the result inside my statement put...