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: Yesterday @ 2:49 PM
Points: 2,163, Visits: 2,150

Thanks for the question.

Post #1052582

L' Eomot Inversé

Posted Monday, January 24, 2011 11:17 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:53 PM
Points: 7,182, Visits: 7,281

Nice straighforward question. I like them like this.

Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

http://es.linkedin.com/in/tomthomsonsoftware

Post #1052591

SQLRNNR

Posted Monday, January 24, 2011 12:52 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 12:32 AM
Points: 18,855, Visits: 12,439

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: Today @ 3:51 AM
Points: 3,163, Visits: 4,342

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: Monday, June 10, 2013 7:59 PM
Points: 1,491, Visits: 3,010

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