ASP search screen and MS-SQL 2k

[rdlebreton]

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

[Jerry Boone]

Re: ASP search screen and MS-SQL 2k

Look 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@hot mail.com> wrote in message
news:80376060.0 312111117.4f999 bf2@posting.goo gle.com...[color=blue]
> 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[/color]

[Erland Sommarskog]

Re: ASP search screen and MS-SQL 2k

[posted and mailed, please reply in news]

rdlebreton (rdlebreton@hot mail.com) writes:[color=blue]
> 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?[/color]

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/techinfo/productdoc/2000/books.asp

[rdlebreton]

Re: ASP search screen and MS-SQL 2k

Erland Sommarskog <sommar@algonet .se> wrote in message news:<Xns944F3B 58AE2FYazorman@ 127.0.0.1>...[color=blue]
> [posted and mailed, please reply in news][/color]
<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