Predict the total count

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 SQL Buzz » Predict the total count

55 posts, Page 1 of 6

1 2 3 4 5 »»»

Predict the total count

Rate Topic

Display Mode

Topic Options

Author

Message

bazzkar

Posted Thursday, November 04, 2010 9:34 PM

SSC-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

john.arnott

Posted Thursday, November 04, 2010 9:45 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, June 10, 2013 7:59 PM
Points: 1,491, Visits: 3,010

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

Koen Verbeeck

Posted Friday, November 05, 2010 1:52 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:30 AM
Points: 9,410, Visits: 6,495

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

Bob Cullen-434885

Posted Friday, November 05, 2010 2:11 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 06, 2013 1:30 AM
Points: 515, Visits: 390

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

Jinx-640161

Posted Friday, November 05, 2010 2:11 AM

Old 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

micniv

Posted Friday, November 05, 2010 2:12 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 28, 2010 2:22 PM
Points: 33, Visits: 30

Interesting question
but the correct answer is ... 1

Post #1016402

Peter Rijs

Posted Friday, November 05, 2010 2:28 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:53 AM
Points: 856, Visits: 580

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

Christian Buettner-167247

Posted Friday, November 05, 2010 2:31 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:36 AM
Points: 2,547, Visits: 3,648

No comment, next question... :)

Best Regards,
Chris Büttner

Post #1016410

selyod

Posted Friday, November 05, 2010 2:47 AM

SSC 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

honza.mf

Posted Friday, November 05, 2010 2:50 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 4:19 AM
Points: 1,115, Visits: 1,210

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.

Post #1016415

« Prev Topic | Next Topic »

55 posts, Page 1 of 6

1 2 3 4 5 »»»

Permissions