Yes the paging is also done i have taken the query into stored procedure there i used the temp table and when my application request me the number of rows...

RGR'us

Very fast not even one second retrieves nearly 10,000 rows

Enthusiast

All indexes are done , before indexing it is more slower

335K

RGR'us

Check the below query this returns me  3,34,516 rows

SELECT JS.Code, FC.Name, JS.CompanyCode FROM JOBS JS LEFT OUTER JOIN CUSTOMERS FC ON JS.Code = FC.CCode and JS.GNumb = FC.GNumb

WHERE JS.sdate...

RGR'us

We need to display all these rows in a LOOK UP screen where the user can select the code  , we are using date ranges to display the result set but in...

My Executions Plan

 |--Sort(ORDER BY[JS].[Sdate] DESC, [JS].[Code] ASC))

       |--Hash Match(Right Outer Join, HASH[FC].[CCode], [FC].[GNumb])=([JS].[CCode], [JS].[GNumb]), RESIDUAL

My query is as below

SELECT JS.Code, FC.Name, JS.CompanyCode FROM JOBS JS LEFT OUTER JOIN CUSTOMERS FC ON JS.Code = FC.CCode and JS.GNumb = FC.GNumb

ORDER BY JS.sdate desc ,...

Follow the below two steps 

Step 1.

BACKUP LOG HR_database WITH TRUNCATE_ONLY

Step 2.

DBCC SHRINKFILE(HR_database_log,5)

Your log should come to 5 MB

Cheers

Krishna

Thanks Phill

Yes for ORDER BY it is working i have implemented in many queries, but for condition problem occurred , any way Thanks for the reply no way to run now ....