Re: TSQL Help



hi
try to implement index on COLLECTION_PAYMENT_PERIOD_ID
this might improve the performance of ur query

best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***
.



Relevant Pages

  • RE: SQLDTS File Transfer Protocol Task
    ... Post a query to sqldtsftp@xxxxxxxxxxxxxxxxxxxxx ... thanks and regards ... Chandra ... Prev by Date: ...
    (microsoft.public.sqlserver.dts)
  • Re: Looking for sample code
    ... > A query that uses the following definition for a table: ... > UPDATEs. ... Prev by Date: ...
    (comp.databases.oracle.tools)
  • Re: Global Variable
    ... in the bas file ... best Regards, ... Chandra ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • Re: Help with a list variable
    ... This is not correct but a quick fix ... best Regards, ... Chandra ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Downgrade SQL Server edition
    ... best Regards, ... Chandra ... Prev by Date: ...
    (comp.databases.ms-sqlserver)

Loading