Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cowboyinbrla
Starting Member
1 Post |
 Posted - 2010-02-26 : 19:08:42
|
Part of our operation involves storing and full-text indexing of hundreds of thousands of documents (all in PDF form), for which we use the built-in Index Server in Windows Server 2003 for queries (via an ASP page web interface). From this search we can obtain the path & filename for the matching documents, like this:c:\dir1\dirA\doc1334.pdfc:\dir1\dirC\doc1423.pdf In a SQL database, meanwhile, we have certain key details about each document stored, one of which is the file's path and filename. Each record is created automatically by a simple VBScript ASP page that processes a directory of new incoming files, extracting the key info, moving it to a particular directory based on what it is, and noting the directory and name in the record in the process, like this:c:\dir1\DirA\doc1334.pdf Doc# DocType RevDatec:\dir1\DirC\doc1423.pdf Doc# DocType RevDate Is there any simple (fast) way to match these filenames with their corresponding records in the SQL database, without having to do a separate SQL Server query for each full-text result as I loop through the recordset? |
|
|
|
|
|
Combine SQL Query with IndexServer Query?