Re: Row Order

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Guadala Harry (GMan_at_NoSpam.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 11:16:46 -0800

<<That still doesn't explain why you need things in a particular order>>

Yes - please read my response to Kalen.

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:eMsRa0QwEHA.1452@TK2MSFTNGP11.phx.gbl...
> That still doesn't explain why you need things in a particular order. To
> expedite references to the temp table, you could place an index on it -
> likely one that would support the ORDER BY of your final SELECT, for
> example.
>
> --
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
>
> "Guadala Harry" <GMan@NoSpam.com> wrote in message
> news:eDr0wvQwEHA.3872@TK2MSFTNGP11.phx.gbl...
> << Why is it that you "need for the rows to exist in the temp table in the
> order specified by the ORDER BY clause"? >>
>
> I'm pulling data out of the database for display purposes... pulling data
> from many tables into the temp table - then doing some stuff to it prior
to
> display to the user. Rather than attempting those interim operations on a
> complex SELECT statement that uses a dozen or so joins...
>
> -GH
>
>

Relevant Pages

  • Re: Row Order
    ... order specified by the ORDER BY clause"? ... I'm pulling data out of the database for display purposes... ... from many tables into the temp table - then doing some stuff to it prior to ...
    (microsoft.public.sqlserver.programming)
  • Re: Row Order
    ... Columnist, SQL Server Professional ... << Why is it that you "need for the rows to exist in the temp table in the ... I'm pulling data out of the database for display purposes... ...
    (microsoft.public.sqlserver.programming)
  • Re: Strange Recordset/Query Problem
    ... > display in SQL Server. ... table names for each field in the SELECT clause, ON clauses, and WHERE ... Also, SQL Server is not case sensitive, so you can save your eyes by using ... the IF statement executes the first condition as it should, ...
    (microsoft.public.inetserver.asp.general)
  • Re: T-SQL is not quite there yet
    ... no, the choice is between INSERT-EXEC ... results ought to be called functions, not "stored procedures". ... SQL Server is a server- ... gains only by putting keys on temp tables that had none. ...
    (microsoft.public.sqlserver.programming)
  • Strange Recordset/Query Problem
    ... Access 2000 database to a SQL Server 2000 database. ... display in SQL Server. ... the IF statement executes the first condition as it should, ...
    (microsoft.public.inetserver.asp.general)