Re: SQL: If one item is false, I need a false returning
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 11 Sep 2009 22:25:38 +0200
On Fri, 11 Sep 2009 15:54:48 +0100, David wrote:
(snip)
Once I have that working, I then need to extend that part of the query... I
have another field, RepairAuthType. The contents here are restricted from a
list... Now, I need to combine that with the AuthAssigned... as some
AuthAssigned will not need to tell the screen if it is a false, if you can
see what I mean.
Hi David,
Glad you already figured out the first part. I have to admit that I
don't see what you mean for the second. Please post the following
information:
* The design of your tables, as CREATE TABLE statements. Irrelevant
columns may be omitted, but please include all constraints and indexes.
* Some well-chosen rows of sample data, as INSERT statements. Make sure
that they work agains the tables you post, and avoid any locale specific
date formats.
* Expected results from the sample data posted, plus an explanation
(unless it's self-explanatory).
See www.aspfaq.com/5006 for more details.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.
- Follow-Ups:
- References:
- Prev by Date: Re: fastest way of doing it
- Next by Date: Re: DeleteRecordsOnlyIfValueIsSame
- Previous by thread: Re: If one item is false, I need a false returning
- Next by thread: Re: SQL: If one item is false, I need a false returning
- Index(es):
Relevant Pages
|
Loading
