_sigh_ What am I doing wrong?
rstVal.State, adStateOpen, rstVal.EOF, and rstVal.BOF are all True
rstVal.Recordcount is -1
The relevant part of my parameterized query (cmd.commandtext) is:
create table #DRS1(RejectedClm nvarchar(30) primary key); insert into #DRS1 values (?);
The relevant part of my parameter-inserted query (Replace(cmd.CommandText, "?", cmd.Parameters("parClaimsToQueryThisRun"), , , vbTextCompare)) is:
create table #DRS1(RejectedClm nvarchar(30) primary key); insert into #DRS1 values ('N027FLP00530'),('P079FL832721'),('P079FL832714');