Count Distinct

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 Stewart Campbell » Count Distinct

17 posts, Page 2 of 2

««1 2

Count Distinct

Rate Topic

Display Mode

Topic Options

Author

Message

FargoUT

Posted Monday, January 24, 2011 10:37 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, October 11, 2011 1:51 PM
Points: 341, Visits: 311

I got it right by eliminating the answers which were wrong. Incidentally, maybe this is something specific with SSRS (which I have no experience with), but my initial instinct was to say that none of the answers was correct as the query would return with the following:

"Must declare the scalar variable '@startDate'"

Probably being too nitpicky about that though... BigGrin

Post #1052549

UMG Developer

Posted Monday, January 24, 2011 11:07 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

Thanks for the question.

Post #1052582

L' Eomot Inversé

Posted Monday, January 24, 2011 11:17 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:54 AM
Points: 7,086, Visits: 7,138

Nice straighforward question. I like them like this.

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1052591

SQLRNNR

Posted Monday, January 24, 2011 12:52 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

Good question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1052641

Stewart "Arturius" Campbell

Posted Monday, January 24, 2011 11:08 PM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:48 AM
Points: 3,125, Visits: 4,311

FargoUT (1/24/2011)

Within SSRS, when a query is written with variables like this, when the report is compiled, parameters are build, which must be populated (via user input) before the report is run.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1052874

twalpole

Posted Monday, January 31, 2011 8:11 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, September 15, 2011 11:50 AM
Points: 314, Visits: 35

If requesting parts ordered more than once, need to query for diff > 0

Post #1056214

john.arnott

Posted Monday, January 31, 2011 9:26 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:57 PM
Points: 1,491, Visits: 3,008

twalpole (1/31/2011)

If requesting parts ordered more than once, need to query for diff > 0

Nice catch. The difference is between a count(DISTINCT) and and a straight count. With all unique parts, the count(distinct) would equal the count() and the difference would be zero. With a repeat order for a part, the count(DISTINCT) would be less than the straight-up count().

Post #1056261

« Prev Topic | Next Topic »

17 posts, Page 2 of 2

««1 2

Permissions