
November 30th, 2016, 06:38 AM
|
Registered User
|
|
Join Date: Nov 2016
Posts: 1
Time spent in forums: 2 h 51 m 41 sec
Reputation Power: 0
|
|
Multiple 'Between' requests
Hi, I'm using SQL Server 2012 and I want to use several 'between' requests for results on numbers between specified levels e.g.
WHERE Black BETWEEN 20
AND 30
and Cyan between 20 and 30
and Magenta between 20 and 30
and Yellow between 20 and 30
Currently it only brings back results which meet all criteria, I'd like to have results that have any of the requests not all. So I'm not doing 4 searches for each level e.g.
Where one result has black at 24 and the cyan at 56, and a second result with the cyan at 27 and the black at 33
Any help would be greatly appreciated.
|