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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-02 : 08:20:38
|
Jim writes "I need to be able to compare a list of Item Names in an Excel spreadsheet with a list of Item Names in a table in MS SQL Server 2000.
The proposed overall solution goes as follows:
1. Create a stored procedure that imports the template based Excel Spreadsheet into a temporary table
2. Run another stored procedure that runs a SQL statement comparing the two tables and returning the results of the comparison in a query that can be printed out and analysed.
3. Delete the temp table
---------------
My questions are:
1) Does this seem like the logical solution?
2) How would I write a SQL Statement to do step number 2? I'm looking at the SQL commmands "CONTAINSTABLE" and "FREETEXT", however it seems that these commands are for one string and not a recordset of strings.
Please help!!
Thanks in Advance --
Jim Meyer
EDS, Inc.
" |
|
|
|
|
|
CONTAINSTABLE or FREETEXT??