Re: Question on scope of temp tables created via SP

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JT Lovell (jt_lovell_at_yahoo.com)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 16:30:34 -0400

I agree, which is why all of the data manipulation is in SQL already. VB is
just being used as the presentation layer. The question is how best to
return the multiple output tables to VB so they can be formatted for
display.

If I can use temp tables then it makes multi-user versioning a lot easier.
If I have to use real tables, then it adds additional complexity that I'd
rather avoid if at all possible. 

-- 
JT Lovell
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:u1JzhAelEHA.592@TK2MSFTNGP11.phx.gbl...
> One question I would ask yourself here is whether you actually need to
> materialize these summaries as tables for further processing in VB. If
that
> VB process is simply more data manipulation then maybe there is a
> possibility to put that logic into SQL (SQL is generally more nifty at
data
> manipulation than VB!). In that way you might be able to avoid using a
temp
> table at all and just return the end result from a query in your SP. I'm
not
> saying your approach should never be necessary, just that you should
> consider the SQL-based option as well.
>
> -- 
> David Portas
> SQL Server MVP
> --
>
>

Relevant Pages

  • Re: Data Access...
    ... It would be nice if we could get an ANSI standard SQL compliant way to ... Data manipulation, navigation, etc... ... The same way SQL Server and every other SQL compliant database handles it. ... Using the ANSI standard is a better soution, ...
    (microsoft.public.dotnet.framework)
  • Re: Possible bridges between OO programming proponents and relational model
    ... statement...Everything in my experience teaches me that the current SQL ... systems...Do you mean SQL based systems (ORACLE, DB2, SQL Server) ... physical implementation of relational concepts...Is Java a potentially ... language than SQL for data manipulation, ...
    (comp.databases.theory)
  • Re: Cant export actual text - Get #### instead
    ... Thank you, yes the cells were formatted as Text, I changed them to ... General and it worked just fine in exporting the info. ... Now off to figure out my SQL issue, SQL does not like the data for some ... arrrgh, got to love data manipulation, nothing is ever as simple as it ...
    (microsoft.public.excel.misc)
  • Re: Possible bridges between OO programming proponents and relational model
    ... statement...Everything in my experience teaches me that the current SQL ... implementation have recurring problems because they actuall y do not ... >>What do you exactly mean by handling processes ... language than SQL for data manipulation, ...
    (comp.databases.theory)
  • Re: How to Create Local Temporary Table
    ... As Daniel pointed out, many times, it is locking that forces one to look at temp tables and Oracle does not share this problem. ... With the improvements in Oracle 9i and 10g and what Oracle has added to its SQL feature set, one can most often get by with just a single SQL statement, which is more efficient than writing data to a table and then reading it back again. ... If it places the group's minds at ease DB2 supports neither VARRAY nor local temps. ...
    (comp.databases.oracle.server)