User Profile

Collapse

Profile Sidebar

Collapse
Bobwhosmiles
Bobwhosmiles
Last Activity: Jul 30 '07, 02:33 PM
Joined: Aug 31 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Bobwhosmiles
    started a topic Max of Count
    in Access

    Max of Count

    Hi,

    I use access to query a Jet database full of info about members of a club.

    Each attendance by each member at any of 18 sites is recorded in a table called qptHisAttendanc e

    I'm trying to create a query that will list each member ID in the first column and the site ID for the site they've visited most in the last 30 days.

    So far I've got two queries. The first lists all the visits made...
    See more | Go to post
    • Bobwhosmiles
      replied to Return a string representing the day of the week
      in SQL Server
      For anyone else wanting to do the same - it does work!

      Thanks for all your help everyone!
      See more | Go to post

        Leave a comment:

      • Bobwhosmiles
        replied to Return a string representing the day of the week
        in SQL Server
        Maybe someone could paste...

        SELECT LEFT(DATENAME(w eekday, GETDATE()),3) As DAY

        ...into Query Analyzer and tell me what they get (should be the first three letters of the name of the current day of the week)
        See more | Go to post

          Leave a comment:

        • Bobwhosmiles
          replied to Return a string representing the day of the week
          in SQL Server
          After much hunting around online I've found the DATENAME function which apparently when used with "weekday" as per the example below returns a string like "Sunday", "Monday" or whatever based on the day of the week that correlates to the date

          Code:
          DATENAME(weekday, Activity.StartDateTime)
          However, now that I'm at home (not work where I have enterprise manager) I can't test this. Ideally...
          See more | Go to post

            Leave a comment:

          • Bobwhosmiles
            started a topic Return a string representing the day of the week
            in SQL Server

            Return a string representing the day of the week

            Hi All,

            New to the forum and new to T-SQL

            I'm trying to add a column to the results of query that shows a text string representing the day of the week.

            Code:
            Select Activity.StartDateTime as DAY
            ...returns the full date and time. I just want the day of the week.

            I know it's possible to return an integer which represent the day of the week, and I know there's a way to specify which...
            See more | Go to post
            No activity results to display
            Show More
            Working...