Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Netherlands
    Posts
    98

    Unanswered: Need some advice for a query

    HI all,

    I use this query for some stats but the problem with it is, i can't sort on the day. Can someone help me with this query so that i can see the unique hits a day sorted by day?

    Code:
    SELECT CONVERT (varchar, SessionStart, 106) AS dag, 
    COUNT(DISTINCT IPAdress) AS visitors 
    FROM tblStats 
    WHERE Crawler = 'False' 
    GROUP BY CONVERT (varchar, SessionStart, 106)
    Cheers Wim

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by Wimmo
    HI all,

    I use this query for some stats but the problem with it is, i can't sort on the day. Can someone help me with this query so that i can see the unique hits a day sorted by day?

    Code:
    SELECT CONVERT (varchar, SessionStart, 106) AS dag, 
    COUNT(DISTINCT IPAdress) AS visitors 
    FROM tblStats 
    WHERE Crawler = 'False' 
    GROUP BY CONVERT (varchar, SessionStart, 106)
    Cheers Wim
    Try using one of the other formats? Maybe 111 or 120?

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Oct 2003
    Location
    Netherlands
    Posts
    98
    Quote Originally Posted by hmscott
    Try using one of the other formats? Maybe 111 or 120?

    Regards,

    hmscott
    Thanx 111 certainly solves my problem!

    Regards Wim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •