Question of the Day for 20 Oct 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Testing Center » Question of the Day (QOD) » Question of the Day for 20 Oct 2005

Question of the Day for 20 Oct 2005

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Monday, October 17, 2005 4:05 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the Question of the Day for 20 Oct 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=625.

Post #229538

Vladan

Posted Thursday, October 20, 2005 4:57 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 05, 2011 1:38 AM
Points: 1,636, Visits: 604

The most interesting thing is, why the result column is labelled "day of week"... probably to confuse enemy agents

Post #230566

Ninja's_RGR'us

Posted Thursday, October 20, 2005 7:14 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 8:44 PM
Points: 21,376, Visits: 9,585

That's the only read I had to reread it... QQ was pretty easy to remember

Post #230647

Francisco Lopez

Posted Thursday, October 20, 2005 5:52 PM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 12, 2012 11:03 AM
Points: 455, Visits: 45

You can northwind this question like this...
select
datepart(qq, orderdate) 'day of week'
, count(*)
from orders
group by
datepart(qq, orderdate)
you get...

4 202
3 173
2 181
1 274

{Francisco}

Post #230997

kapil_kk

Posted Monday, November 19, 2012 3:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:11 AM
Points: 1,130, Visits: 1,278

good question...
day of week for qq was just a threat Tongue

Post #1386274

« Prev Topic | Next Topic »

Permissions