Ninja's_RGR'us (8/3/2011)
Ninja's_RGR'us (8/2/2011)
UPDATE dbo.AnalysisLog SET @Count = Count = Count + 1 WHERE ...Nevermind that part, I had missed the fact that there's 1 row per date where there's action on the page.
We both did. I was inspired to believe it was a single row first generated when the first click of the page was performed, primarily because of this quote from the article:
When a web page is accessed, Query #2 runs first, looking to see if that particular article has ever been viewed before or not. If not, then another query (which is not in the top 10 list) is run to create a new record where clicks are tracked in a table;
Brad, can you clarify please?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA