ASP search screen and MS-SQL 2k

Hello,

I am looking for help with the following situation.

I have created a simple call tracking system that is integrated
with our accounting / warehousing program in the company. The call
tracking system uses ASP 3.0 and MSSQL 2000 sitting on an Intranet web
server. All appears to be working well with the software. I am
trying to create a search screen to search through the calls based on
different criteria.

I have an ASP script that generates a SELECT statement based on
the selected criteria but this is sent off to the SQL server as the
statement. I want to use a stored procedure to speed up the process.
Is it possible to create a stored procedure for this search even when
the WHERE clause and criteria keeps changing?

TIALook into Full Text Indexing on your SQL Server tables. There is a Sql
Service dedicated to this. This article touches on the capability...

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8967

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz

"rdlebreton" <rdlebreton@.hotmail.com> wrote in message
news:80376060.0312111117.4f999bf2@.posting.google.c om...
> Hello,
> I am looking for help with the following situation.
> I have created a simple call tracking system that is integrated
> with our accounting / warehousing program in the company. The call
> tracking system uses ASP 3.0 and MSSQL 2000 sitting on an Intranet web
> server. All appears to be working well with the software. I am
> trying to create a search screen to search through the calls based on
> different criteria.
> I have an ASP script that generates a SELECT statement based on
> the selected criteria but this is sent off to the SQL server as the
> statement. I want to use a stored procedure to speed up the process.
> Is it possible to create a stored procedure for this search even when
> the WHERE clause and criteria keeps changing?
> TIA|||[posted and mailed, please reply in news]

rdlebreton (rdlebreton@.hotmail.com) writes:
> I am looking for help with the following situation.
> I have created a simple call tracking system that is integrated
> with our accounting / warehousing program in the company. The call
> tracking system uses ASP 3.0 and MSSQL 2000 sitting on an Intranet web
> server. All appears to be working well with the software. I am
> trying to create a search screen to search through the calls based on
> different criteria.
> I have an ASP script that generates a SELECT statement based on
> the selected criteria but this is sent off to the SQL server as the
> statement. I want to use a stored procedure to speed up the process.
> Is it possible to create a stored procedure for this search even when
> the WHERE clause and criteria keeps changing?

Yes, although the way to gain speed is more likely to review indexing,
or constrain what users can search on.

Anyway, I have an article on the topic on my web site. It's a bit
long, but it covers the topic fairly extensively. The link is
http://www.algonet.se/~sommar/dyn-search.html.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog <sommar@.algonet.se> wrote in message news:<Xns944F3B58AE2FYazorman@.127.0.0.1>...
> [posted and mailed, please reply in news]
<snip!
Holy S--!

You've got a lot on this web site!

It's going to take me the whole weekend to digest it all.

Thanks

Argghh ..

OK. I'm officially insane.
I've managed to create an orphaned push subscription. I deleted the
subscribers from EM via the publisher screen, then I deleted the publishers.
But under replication|subscribers there is still a subscriber to a
publication that does not exist.
It seems my efforts to discover ways to break replication are paying off.
Bob Castleman
Replicating Suicidal Tendencies
Try sp_dropsubscriber and sp_dropsubscription.
"Bob Castleman" <nomail@.here> wrote in message
news:uuGDxaNrFHA.3720@.TK2MSFTNGP14.phx.gbl...
> OK. I'm officially insane.
> I've managed to create an orphaned push subscription. I deleted the
> subscribers from EM via the publisher screen, then I deleted the
> publishers. But under replication|subscribers there is still a subscriber
> to a publication that does not exist.
> It seems my efforts to discover ways to break replication are paying off.
> Bob Castleman
> Replicating Suicidal Tendencies
>
>
|||Had already tried that. Didn't work. Ultimately used sp_dropdistributor.
Development servers are so much fun.
Any clue as to how I can end up with orphaned subscriptions? It seems
dropping things through EM would be relatively safe and it would clean up
after itself.
"ChrisR" <noemail@.bla.com> wrote in message
news:eWaSy3XrFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Try sp_dropsubscriber and sp_dropsubscription.
>
> "Bob Castleman" <nomail@.here> wrote in message
> news:uuGDxaNrFHA.3720@.TK2MSFTNGP14.phx.gbl...
>