I'm using a cnn = New ADODB.Connection, to get some data from SQL SERVER 2008R2
When I run my simple select statment below, I'm getting thousands of records back. (in the sample attached, I should have received back the first 3 records back only).
if I run the same script inside SQL, I get the proper results. (one record per Tracking).
Any help is appreciated.
Dim cnt As Integer
Dim i As Integer
For i = 2 To Range("A2").End(xlDown).Ro
w + 1
cnt = cnt + 1
cnn.Open "Provider=SQLOLEDB.1;User ID= xxxxxxxxxxxxxxxxxxxx
sql = "Select OrderNo, " & _
"NoteNumber from FinalizedOrderNotes " & _
"where NoteText Like ('%" & sh.Cells(i, 1) & "%') "
rs.Open sql, cnn, adOpenDynamic, adLockOptimistic
sh.Cells(i, 2).CopyFromRecordset rs