Re: Counting the occurence of a string ...
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sun, 27 Aug 2006 09:24:30 +0000 (UTC)
DaFerg (dave@xxxxxxxxxxx) writes:
I have a weblog database where I want to count the occurences of a
table of string values that appear in all the urls viewed.
My tblWebLog as a field that contains the url ...
tblWebLog.[cs-uri-stem]
I have another table ... tblStrings ... that has a field [strSearch]
for a string value and an integer field [intViewCount] to count the
occurence of the string in tblWebLog.[cs-uri-stem]
I've been trying ...
Update tblStrings
Set [intViewCount] = (Select Count(*) From tblWebLog Where
[cs-uri-stem] Like '%_' + tblStrings.[strSearch] + '.htm%')
... but it doesn't fly and I'm stumped. Any thoughts?
Your query make sense in relation to your description, but then again I
may be misunderstanding something.
For this sort of question, it helps if you post:
o CREATE TABLE statements for your tables.
o INSERT statements with sample data.
o The desired result given the sample.
This helps to clarify what you are looking for, and it makes it possible
to copy and paste and develop a tested solution.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Counting the occurence of a string ...
- From: DaFerg
- Counting the occurence of a string ...
- Prev by Date: Counting the occurence of a string ...
- Next by Date: Re: Counting the occurence of a string ...
- Previous by thread: Counting the occurence of a string ...
- Next by thread: Re: Counting the occurence of a string ...
- Index(es):
Relevant Pages
|
