[dba-SQLServer] Dynamic from Access

On 7 Nov 2004 at 22:50, John W. Colby wrote:

> So, how do I hand SQL Server a dynamically built SQL statement, ask it to
> evaluate the SQL statement and return a single count value?
> 
Use an ADO connection.

> Eventually I also need to have SQL take that same where clause and hand me
> back a set of fields / records from the main name / address subtable for
> sending to the bulk mail client.
> 

Same thing, you just get a Recordset back

-- 
Stuart