Re: How to improve performance of the report's display while updating the table?

From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 14:14:11 -0500

Uri was saying that your select has an error in it, but it does not. ( He
probably was just looking quickly.) Each one of the tables is in the where
clause, but you are using an OLD style syntax which is VERY prone to the
kinds of errors that Uri mentioned... Why don't you spend some time getting
used to and using the ANSI style join syntax - you'll be better off .... IE

select * from a inner join b with (nolock) on a.id = b.id
    inner join c on b.id = c.id
    inner join d on c.id = d.id; 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"@Ariel" <anonymous@discussions.microsoft.com> wrote in message
news:8647D87B-C082-485D-8BFF-1B822C33FA8D@microsoft.com...
> Thanks Uri and Wayne.
>
> Yes, my table got join statements within.
>
> select * from table a, table b with (nolock), table c and table d
> where a.id = b.id and
>           b.id = c.id and
>           c.id = d.id;
>
> // the b table I assume is the attendance table.
>
> uri, did you mean that my result will be wrong after I use the nolock
syntax?
> Or you mean it will be wrong in terms of some of the data it linked will
be deleted or updated?
>
> Thanks Again
>

Relevant Pages

  • Re: URL encoding api in Java 1.4.2
    ... reserved characters in URI syntax, ... Append the resulting string to the submission URL, ... dubious about the interaction between x-www-form-urlencoding and URI ...   If the method is "get" and the action is an HTTP URI, ...
    (comp.lang.java.programmer)
  • Re: URL encoding api in Java 1.4.2
    ... Second is x-www-form-urlencoding of the query part, ... reserved characters in URI syntax, ... i'm a bit dubious about the interaction between x-www-form-urlencoding and URI escaping. ... Percent-Encoding Normalization ...
    (comp.lang.java.programmer)
  • Re: urlencode vs rawurlencode
    ... | This method was used to make query URIs easier to pass in systems ... in the query component of an HTTP URL. ... A URI may contain ... Syntax and Escaping", ...
    (comp.lang.php)
  • Re: Web authentication
    ... RFC 2396: Uniform Resource Identifiers (URI): Generic Syntax ... Server-based Naming Authority ... specified server on the Internet use a common syntax for the server ...
    (comp.lang.python)
  • Re: Time range matching
    ... IF you are trying to get all emps born during certain hourly ranges without ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > Dear Uri, ... > Declare @A varchar ...
    (microsoft.public.sqlserver.server)