Ok, I am racking my head over how to efficently do this in Sql Server 2000. This code is going slow.......very slow.......and direction would be appreciated.
dim rs1
dim rs2
dim cn
dim sSql
dim cmd
' instantiate the ADO objects
set cn = CreateObject("A DODB.Connection ")
cn.Open = "Provider=SQLOL EDB;Data Source=(Local); Initial Catalog=Ave;Use r...