Count occurence of a word

How can I count the rows in wich a specific word occurs in a field in the
detail row of a report?
Thanks
HThere are at least two approaches that come to my mind.
1. Add a caculated field to your dataset that calls a custom VB function
(either embedded in the report or external) which counts the words per row.
Then use the Sum() function to get the overall total.
2. Add a class-level variable to the report embedded code that keeps a
running total. Call a VB function from the field that needs to be counted.
HTH
--
----
Teo Lachev, MVP, MCSD, MCT
Home page and blog: http://www.prologika.com/
----
"Hennie" <spam_me@.linux.com> wrote in message
news:3F608B1B-5F27-4249-912E-0360B60C93FD@.microsoft.com...
> How can I count the rows in wich a specific word occurs in a field in the
> detail row of a report?
> Thanks
> Hsql

Could not complete cursor operation !

Hi.
Following eror occurs in a stored procedure..
Could not complete cursor operation because the set options have
changed since the cursor was declared.
What r the possible reasons!
rgds
AjayMaybe you could post the code?

And why are you using a cursor?

Corrupted indexed view

Windows Server 2003
SQL Server 2000 Enterprise
One of our indexed views is periodically getting corrupted. When it
occurs, one of the aggregate money fields returns an incorrect value.
Rebuilding the view corrects the problem.
This is a financial system and these incorrect money amounts are
causing major problems. But removing the indexed view causes certain
summation functions of the system to be unacceptably slow.
How do I fix?You should probably contact PSS to get tot he root of the problem.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly SQL MVP
<thegap2@.excite.com> wrote in message
news:1129901119.648845.24860@.o13g2000cwo.googlegroups.com...
> Windows Server 2003
> SQL Server 2000 Enterprise
> One of our indexed views is periodically getting corrupted. When it
> occurs, one of the aggregate money fields returns an incorrect value.
> Rebuilding the view corrects the problem.
> This is a financial system and these incorrect money amounts are
> causing major problems. But removing the indexed view causes certain
> summation functions of the system to be unacceptably slow.
> How do I fix?
>