Speed up query

Hello,

I have 2 tables on SQL Server 2000. I need to read some values from one table and search for those values in the second table. I'm using this method:

- Query for all matching records in table 1.

- Put the results in an array (with GetRows).

- Loop through that array and query for records.

The problem is, for only 25 matched records from table 1, it takes about 20 seconds to search the second table. I believe this is too long. What should I do to speed up this operation?

Thanks in advance.

This is the first query:

sSQL = "select distinct TAC_ID from TAC_GRP"
rsConfig.CursorType = 3
rsConfig.Open sSQL, objConn
iTotalGroups = rsConfig.RecordCount
rsArray = rsConfig.GetRows
rsConfig.Close

At this point, rsArray contains 25 elements. 

And this is the second query:

For iCount = 0 To (iTotalGroups - 1)
sGroup = rsArray(0, iCount)
sSQL = "select * from TAC_USR where TAC_ATTR='[Global]Groups' and TAC_VAL like '%" & sGroup & "%'"
rsConfig.CursorType = 3
rsConfig.Open sSQL, objConn
Response.Write("<tr>" & vbCRLF)
Response.Write("<td nowrap>" & vbCRLF)
Response.Write("<p align=""left"">"& sGroup & vbCRLF)
Response.Write("</td>" & vbCRLF)
Response.Write("<td nowrap>" & vbCRLF)
Response.Write("<p align=""center"">" & rsConfig.RecordCount & vbCRLF)
Response.Write("</td>" & vbCRLF)
Response.Write("</tr>" & vbCRLF)
Response.Write("<tr><td width=50% height=5></td>")
Response.Write("<td width=50% height=5></td></tr>")
rsConfig.Close
Next

Thanks for your attention.