SELECT DISTINCT "MCOMP"."MCMP_NAME", "MLOC"."MLOC_NAME", "MDEP"."MDEP_NAME", "TDAY"."TDAY_EMPCDE", "MEMPOFF"."MEMP_NAME", "TDAY"."TDAY_SFTREPO", "TDAY"."TDAY_DATE", "TDAY"."TDAY_EXHR", "TDAY"."TDAY_SFTASSG", "MEMPOFF"."MEMP_CODE"
 FROM ((("krishna"."dbo"."TDAY" "TDAY" INNER JOIN "krishna"."dbo"."MEMPOFF" "MEMPOFF" ON "TDAY"."TDAY_EMPCDE"="MEMPOFF"."MEMP_CODE") INNER JOIN "krishna"."dbo"."MCOMP" "MCOMP" ON "MEMPOFF"."MEMP_CMPCD"="MCOMP"."MCMP_CODE") INNER JOIN "krishna"."dbo"."MDEP" "MDEP" ON "MEMPOFF"."MEMP_DEPCD"="MDEP"."MDEP_CODE") INNER JOIN "krishna"."dbo"."MLOC" "MLOC" ON "MEMPOFF"."MEMP_LOCCD"="MLOC"."MLOC_CODE"
 ORDER BY "MCOMP"."MCMP_NAME", "MLOC"."MLOC_NAME", "MDEP"."MDEP_NAME", "MEMPOFF"."MEMP_NAME"

I am using Crystal Report XI and SQL Server 2000.
This is my SQL Query,Generated by the Database -> Show SQL Query.
If I am running this Query in SQL Query Analyzer than it takes above 15 min to show the output, and there are 1039131 records from this output.
Is there is any way to reduse the time it takes to show the output.

Thanks

Regards,
     Komal.

I think it will be very dificult for any of us to help you without seeing the data and the database and what are the tables... :(

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========