Re: compact where clause

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

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 06/24/04

Next message: Uri Dimant: "Re: Are there performance impact inserting records into Table vs View?"
Previous message: Mingqing Cheng [MSFT]: "RE: Error restoring database with VDI for SQL Server 7.0"
In reply to: ben h: "compact where clause"
Messages sorted by: [ date ] [ thread ]

Date: Thu, 24 Jun 2004 07:27:59 +0100

You can try this:

...
WHERE 'user' IN (ownerid, originatorid, actioneeid)

-- 
David Portas
SQL Server MVP
--

Next message: Uri Dimant: "Re: Are there performance impact inserting records into Table vs View?"
Previous message: Mingqing Cheng [MSFT]: "RE: Error restoring database with VDI for SQL Server 7.0"
In reply to: ben h: "compact where clause"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: for updae trigger question
... I will try to generate the triggers that way so the ... >> Rather than write dynamic SQL into your production code why not write ... >> David Portas ... >> SQL Server MVP ...
(microsoft.public.sqlserver.programming)
Re: sql - question
... > David Portas ... > SQL Server MVP ... Your guidance has been useful to me. ... it's value as zero. ...
(microsoft.public.fox.vfp.queries-sql)
Re: Extremely Slow Trigger Problem
... been working okay up until about a week ago, and I think there is an ... cost so much to open that cursor with 1 row in the inserted/deleted tables. ... "David Portas" wrote: ... > SQL Server MVP ...
(microsoft.public.sqlserver.programming)
Re: SELECT INTO AND ORDER BY?
... > the ORDER BY clause: ... > In fact you can't control the order in which IDENTITY values are assigned ... > David Portas ... > SQL Server MVP ...
(microsoft.public.sqlserver.programming)
RE: Using variable column-names
... help, please post DDL, sample data INSERTs and required results. ... David Portas ... SQL Server MVP ...
(microsoft.public.sqlserver.programming)