Can somebody help me to optimize this query
I am a newbie on SQL Server. I am using SQL Server 2012. In this query, my query takes about 7 seconds to return nearly 13K rows. I could see that there is a huge difference between Estimated Rows and Actual Rows. I executed the sp_updatestats but the difference still remained. Can somebody pl. guide me towards any scope of optimizing this query. Thanks.