Thanks. That means I have to add a GROUP BY CLAUSE for the JOIN query to filter on the rows.

Try using SQL-DMO! Look in BOL for syntax and examples.

DISTINCT does not take advantage of Indexes!

Try using GROUP BY Instead with an INDEX on Prcs_dte

Try this.

CONVERT(VARCHAR(20), DateColumn)

This forum requires some serious enhancements! I have to rewrite the entire post because the "Edit" button has cleared out the original post!

You should place the Database in singleuser mode(this...