Viewing 4 posts - 571 through 575 (of 575 total)
Try using SQL-DMO! Look in BOL for syntax and examples.
February 5, 2004 at 4:32 pm
#492970
DISTINCT does not take advantage of Indexes!
Try using GROUP BY Instead with an INDEX on Prcs_dte
February 5, 2004 at 4:30 pm
#492969
Try this.
CONVERT(VARCHAR(20), DateColumn)
February 5, 2004 at 4:22 pm
#492968
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...
January 29, 2004 at 6:11 pm
#492274