Re: Using recordset as table

From: Ennex (Ennex_at_discussions.microsoft.com)
Date: 03/03/05 

Date: Thu, 3 Mar 2005 11:19:07 -0800

Hi Dave,

> As Bob said, there's no way to do this on the client-side ADO interface.
> Your SQL query text is being sent to the SQL server. An ADO recordset can't
> be referenced in the query because the SQL server doesn't know anything
> about ADO recordsets being held on the client side.

     I've been confused by the use of "client" here. I thought you guys
meant it as in "client-server," but apparently you mean something else.

>
> However, if you are using Microsoft SQL Server you could define a VIEW that
> represented your common query and then do "subqueries" off of that. See the
> SQL docs for views and how to define them.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_2d9v.asp

     BINGO. That's exactly what I was asking for. Views seem to do exactly
what stored queries do in Access, which is what I needed. I've tested in on
both my development machine and on the Web server, and it seems to do the
trick.

     THANK YOU !!!!!

Marshall Burns

Relevant Pages

  • Re: Using recordset as table
    ... Your SQL query text is being sent to the SQL server. ... An ADO recordset can't ... about ADO recordsets being held on the client side. ...
    (microsoft.public.scripting.jscript)
  • Re: RAISERROR() NOT POUP MESSAGE ?
    ... MSDE is the same as SQL Server. ... write the client application so it does some sort of popup... ... >>>I have used raiserrorin my Sql Query but its output is printing within the Query Analyzer and ...
    (microsoft.public.sqlserver.programming)
  • Re: Can you use osql in DTS?
    ... Columnist, SQL Server Professional ... It has a SQL Query ... "Tom Moreau" wrote in message ... Use as DTS Data Pump task and use the stored proc call in the SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... Columnist, SQL Server Professional ... It has a SQL Query ... "Tom Moreau" wrote in message ... Use as DTS Data Pump task and use the stored proc call in the SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: RAISERROR() NOT POUP MESSAGE ?
    ... How your client application handles it depends entirely on the nature ... "Luqman" wrote in message ... >>>I have used raiserrorin my Sql Query but its output is printing ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)