Let me start by saying Thanks for all the suggestions. However, I did make a mistake when I posted my original script. In the Where clause, ‘Select ID2’...

Thanks Everyone... it works now.

It was a combination of the SET NOCOUNT ON and cn.CursorLocation = adUseClient. When I added these to my code and it worked.

I did try...

For the connection:

Set cn = New ADODB.Connection

cn.ConnectionString = "User ID = USER; Password = PASS;" & _

...

The command to open the recordset should have read:

rs.Open "Exec sp ", cnDataTable

where cnDataTable was defined and opened earlier in the app.

The RETURN was in the sp from an earlier...

I had the same problem so I use the following:

WHERE Convert(varchar(10),date_key,101) Between @Startdate and @EndDate

@Startdate being '10/16/2002'

@EndDate being '10/25/2002'

Edited by - cfeisel on 12/02/2003 10:29:34 AM