I have a recordset object created with something like the following:

MyRs = CreateObject("AdoDb.RecordSet") 
WITH MyRs
	.Fields.Append("RowNo", adInteger) 
	.Fields.Open 
	.AddNew 
	.Fields(0).Value = 1
	.AddNew
	.Fields(0).Value = 2
	*-- And so on
EndWith

What i need to do is to use this recordset in a subquery on SQL Server 2000 without creating a temp table. something like:

MySql = "Select * From MyTable Where IdNo IN ( MyRs.Fields..... )

And then use SPT Or another Rs to get my result, anybody ?

Thanks