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

Question of the Day for 20 Oct 2005 Expand / Collapse
Author
Message
Posted Monday, October 17, 2005 4:05 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, 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
Posted Thursday, October 20, 2005 4:57 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 5, 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
Posted Thursday, October 20, 2005 7:14 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:44 AM
Points: 21,405, Visits: 9,617
That's the only read I had to reread it... QQ was pretty easy to remember .
Post #230647
Posted Thursday, October 20, 2005 5:52 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-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
Posted Monday, November 19, 2012 3:33 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:27 AM
Points: 1,890, Visits: 2,329
good question...
day of week for qq was just a threat



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1386274
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse