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 4, 2010 9:34 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, September 3, 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 4, 2010 9:45 PM


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
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 5, 2010 1:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
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 5, 2010 2:11 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 5:13 AM
Points: 678, Visits: 531
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 5, 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 5, 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 5, 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: Tuesday, November 25, 2014 2:47 AM
Points: 898, Visits: 602
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
Post #1016409
Posted Friday, November 5, 2010 2:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:56 AM
Points: 2,842, Visits: 3,876
No comment, next question... :)

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

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:23 AM
Points: 1,409, Visits: 1,316
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