User Profile

Collapse

Profile Sidebar

Collapse
gullguten
gullguten
Last Activity: Dec 19 '06, 02:41 PM
Joined: Jun 1 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gullguten
    replied to Produce calculated fields
    in General
    Thanks for answering my question.

    After I posted my question I spent 'bout 30 minutes to implement a SP to solve my problem. And I have used your approach in my current version like this:
    Create temporary table
    Insert all articleIDs
    Insert count for last 24 hours for give articleID
    Insert count for last week for given articleID

    Select-statement to return a recordset to the ASP-page
    ...
    See more | Go to post

      Leave a comment:

    • gullguten
      started a topic Produce calculated fields
      in General

      Produce calculated fields

      Hello folks. I'm new in this forum, but I have not found my question answered anywhere here so I guess it's OK for me to post it.

      I have the following case.
      Table [articleviews]
      av_id
      av_ip
      av_datetime

      This table records every presentation of any articles in my system.
      The field [av_datetime] holds the date and time like yyyymmddhhmmss (14 chars)

      What I would...
      See more | Go to post
      No activity results to display
      Show More
      Working...