Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Count Distinct Expand / Collapse
Author
Message
Posted Monday, January 24, 2011 10:37 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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...
Post #1052549
Posted Monday, January 24, 2011 11:07 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Thanks for the question.
Post #1052582
Posted Monday, January 24, 2011 11:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 7,868, Visits: 9,607
Nice straighforward question. I like them like this.

Tom
Post #1052591
Posted Monday, January 24, 2011 12:52 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 17,977, Visits: 15,981
Good question.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1052641
Posted Monday, January 24, 2011 11:08 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:56 PM
Points: 4,119, Visits: 5,485
FargoUT (1/24/2011)
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...


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
Posted Monday, January 31, 2011 8:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Monday, January 31, 2011 9:26 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:53 PM
Points: 1,388, Visits: 3,039
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 »

Add to briefcase ««12

Permissions Expand / Collapse