I require a stored procedure for most frequently visited page for a day. I have tried in many sites but no use. Please do me the favor. The server we are using is SQL SERVER 2005.
OK, nobody is going to write your SP for you. This isn't this kind of forum. Please read the Posting Guidelines and understand that we can't do your assignment/homework for you.
MODERATOR
However, I can get you started in the right direction.
If you want every page view logged, you need to write an entry to your DB in the Page_Load event of every page. Then, it should be a simple SELECT using count(*) and group by page.
I'm using document.referrer method for tracking visits on my site. But it
seems that, when someone finds my site with google, this method returns
only:
"google.com/search?q=xxxxx" (good)
or...
I am using Statcounter to log site visits
Upon enquiring whether the service logged visits from my site to external
sites using site links I was given the following information:-
"You have to...
I am a Access newbie... Hopefully somebody can help me figure this
out.
I have a database that looks like:
Asset Economic Minimum
----- ----------------
10555 ...
I'm a noob SQL user, crossing over from SAS. I have a table with about
200k rows and one of the columns is empssn, which holds the employee
social security number. The same empssn may appear in...
This is my third question about eliminating accounting entries in a
clinical database, yet retaining the valid record. Latest wrinkle is
being able to sum the visits to the doctor, and the units of...
Hi
I have a patient table with patient names and visiting dates. I want to
select those patients who have visited me at least 6 times and show the
dates that they visited ordered by name. I have...
Hi,
I'm having a problem with a query. I'm running Access 2000 and a table
with 35000 rows.
The table contains several visits to the spots with a CODE (spot code)
and DATE (visit date)...
Wrie a function which returns the most frequent number in a list of integers. Handle the case of more than one number which meets this criterion.
public static int GetFrequency(int list)
Hello all, and thanks again for the help, I have been very pleased with the quality posts on this forum!
Here what I need to solve:
I have 2 tables on a db, one is called visitor_log and here...
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...