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 12345»»»

Predict the total count Expand / Collapse
Author
Message
Posted Thursday, November 04, 2010 9:34 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 03, 2010 4:19 AM
Points: 158, Visits: 72
Comments posted to this topic are about the item Predict the total count
Post #1016379
Posted Thursday, November 04, 2010 9:45 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:55 AM
Points: 1,520, Visits: 3,035
Or, if your locality sets the date format as dd/mm/yyyy, then would not the 01/07/2010 row be saved as first of July? That would seem to still result in two matches.

But, are there other national settings that might give a different result?
Post #1016381
Posted Friday, November 05, 2010 1:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 12,178, Visits: 9,130
Nice question, but since this is an international website, it was better to include some information about the server settings of the set-up. Or include some statements like SET DATEFORMAT.

I ran a small test, and if you include the statatement SET DATEFORMAT dmy; at the beginning of the script, the result is 1.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1016396
Posted Friday, November 05, 2010 2:11 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:42 AM
Points: 597, Visits: 458
The question asks us to 'predict' the outcome, which implies you do it by inspection. But how is anyone supposed to know that 40358 is a relevant date serial?
Poorly constructed question, I'd say.
Post #1016400
Posted Friday, November 05, 2010 2:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 16, 2011 8:22 AM
Points: 378, Visits: 353
Hi,

Using UK regional settings my result was 1.

Post #1016401
Posted Friday, November 05, 2010 2:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 28, 2010 2:22 PM
Points: 34, Visits: 30
Interesting question
but the correct answer is ... 1
Post #1016402
Posted Friday, November 05, 2010 2:28 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Saturday, October 26, 2013 2:15 PM
Points: 859, Visits: 592
I agree with Bob: how should we know which date 40358 is, without executing a command?
Poor question, poor explanation as well (as pointed out in some other reactions).


Peter Rijs
BI Consultant, The Netherlands
MCITP BI Dev & DB Dev (SQL 2008 & 2005)
Post #1016409
Posted Friday, November 05, 2010 2:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:19 AM
Points: 2,814, Visits: 3,851
No comment, next question... :)

Best Regards,
Chris Büttner
Post #1016410
Posted Friday, November 05, 2010 2:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 03, 2011 9:50 AM
Points: 43, Visits: 5
Grr. This returns 1 on my setup. Ah well.
Post #1016414
Posted Friday, November 05, 2010 2:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, March 28, 2014 1:51 AM
Points: 1,298, Visits: 1,305
Yes, there are different cultures with different dateformats. Not only strange countries from the east of Europe!
The different order in writing dates in UK and USA was used as a clue by lord Peter Wimsey. I don't rememeber the name of that story.




See, understand, learn, try, use efficient
© Dr.Plch
Post #1016415
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse