Compare Dates in an iterative manner for a particular set of records

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Divya Agrawal » Compare Dates in an iterative manner for a...

42 posts, Page 5 of 5

«««1 2 3 4 5

Compare Dates in an iterative manner for a particular set of records

Rate Topic

Display Mode

Topic Options

Author

Message

AlexT-359331

Posted Thursday, November 13, 2008 2:38 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 05, 2013 8:51 AM
Points: 138, Visits: 574

that means that you have a lot "bad" de dates in table. in reality difference probably will be more significant

Post #602414

Carla Wilson-484785

Posted Thursday, November 13, 2008 2:51 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:00 PM
Points: 1,349, Visits: 1,737

No, actually, only 10,000 PersonIds in my test table of 5 million rows (1 million unique PersonIDs) have records that are out of order; that's about 1% of the ids. That also explains the nice lift, because the subselect has far fewer rows for the distinct to operate on.

Note: the subselect finds roughly 20,000 rows, distinct return 10,000 rows.

Post #602425

« Prev Topic | Next Topic »

42 posts, Page 5 of 5

«««1 2 3 4 5

Permissions