#DateForumTypeThreadPost
926 Sep 2012 @ 01:31 PDTDatabaseReplyDetermine Average Count by Day of Week Ulrich,  Is it possible to add to the previous query incorporating a result set that contains the year with previous year on the SAME row? E.g.  If i select the dates Between '2011-...
821 Sep 2012 @ 07:45 PDTDatabaseReplyDetermine Average Count by Day of Week I would  like to order by the order in a week: East   Sun      East Monday     East Tuesday etc.   West  Sun West Monday ...
721 Sep 2012 @ 06:32 PDTDatabaseReplyDetermine Average Count by Day of Week This works great.  Thank you for the explanation.  How would you order the days of week like Sunday, Monday, Tuesday etc?   
619 Sep 2012 @ 02:33 PDTDatabaseTopicDetermine Average Count by Day of Week How would I compute an AVERAGE for each day of week between a date range i.e. August through September on a Count?   An average for FRI, SAT, SUN etc.  E.g if there are 6 Thursdays i...
508 Sep 2012 @ 01:05 PDTDatabaseReplyPivot Data by Month Ulrich,   The State_IND just has the State abbreviation i.e. AL, TN.   When i pasted it, it included 1, 2 etc, which is not part of the field. The source table only contains the CM...
407 Sep 2012 @ 08:34 PDTDatabaseTopicPivot Data by Month How would I make this result look like the second result?   STATE_IND           State_Count     ...
330 Aug 2012 @ 06:42 PDTDatabaseReplyBetween Times not working Ulrich,    I got it to work as this.  Thanks for your help.     SELECT ASKME_CREAT_TM, cast(ASKME_CREAT_TM as time) , case when ASKME_CREAT...
230 Aug 2012 @ 06:30 PDTDatabaseReplyBetween Times not working ASKME_CREAT_TM is a [TIME(0)] field.   I had posted the syntax wrong and corrected it below.    I can do CASE When AskME_CREAT_TM  09:00:00 for example, and it...
128 Aug 2012 @ 02:57 PDTDatabaseTopicBetween Times not working I get error someting between a string or a Unicode character literal and the 'and' keyword.    SELECT CREAT_TM, Case CREAT_TM When ASKME_CREAT_TM Between (...