How to create a table for product view

Jan 4 2012 3:15 PM

hello,

i m application i have product table
now user want to know how much time product view monthly wise and how much time click
so how i create a table for view and click and show the report monthly

plz give me some idea or code for sql server to create a report

thanks