No announcements
Found 1636134 threads
-
0 VotesIs this conditional WHERE clause possible?
" clauses within my WHERE clause?Answered | 4 Replies | 1501 Views | Created by Pelalusa - Saturday, September 27, 2014 2:03 AM | Last reply by --CELKO-- - Saturday, September 27, 2014 5:01 PM
-
3 Votes
Conditional Where clause possible?
Is it possible to use a conditional statements in a where clause?Answered | 9 Replies | 43050 Views | Created by Mainiac007 - Monday, June 11, 2007 3:18 PM | Last reply by Paresh Prajapati - Thursday, May 13, 2010 12:57 PM -
8 Votes
Conditional Split vs Where Clause
Where possible filter your data in the Source Adapter rather than filter the data using a Conditional Split transform component.Answered | 4 Replies | 7223 Views | Created by CSharp Enthusiast - Thursday, February 10, 2011 10:07 PM | Last reply by SSISJoost - Friday, February 11, 2011 8:10 AM -
3 Votes
"OR" "AND" Condition in where clause in MDX
It will be OR condition !Answered | 14 Replies | 7498 Views | Created by Twikle123 - Wednesday, December 14, 2011 1:30 PM | Last reply by prashanthkthi - Tuesday, October 29, 2013 10:34 AM -
0 Votes
date condition in where clause
Hello , I need to use this in where condition like pick all inquiry counts for yesterday and i have a date dimension.Answered | 7 Replies | 7403 Views | Created by madhavi ajjarapu - Wednesday, February 2, 2011 2:15 PM | Last reply by HrvojePiasevoli - Tuesday, February 8, 2011 5:27 PM -
0 Votes
Is there a way to use a conditional where clause
Here’s another possible skeleton in that style instead of what you’ve written: SELECT <<list of columns and expressions ...Answered | 3 Replies | 9664 Views | Created by Duckkiller53 - Tuesday, August 22, 2017 9:17 PM | Last reply by --CELKO-- - Wednesday, August 23, 2017 12:39 AM -
0 Votes
condition on all columns in where clause
I know this way but as i said i want to know if i could put all columns(in one shot i.e w/o using or/and and applying conditions separately on each one of them) with ...Answered | 5 Replies | 5261 Views | Created by dpkas - Monday, December 3, 2012 10:20 AM | Last reply by dpkas - Tuesday, December 4, 2012 10:27 AM -
1 Votes
Where clause selective condition
Tom's right that this is probably the most efficient way (the part about replicating the query) and Erland's link in his answer is _the_ authority on optional filters in a WHERE ...Answered | 3 Replies | 3068 Views | Created by jrobinsontx - Tuesday, September 18, 2012 9:30 PM | Last reply by RichardTheKiwi - Wednesday, September 19, 2012 1:12 AM -
0 Votes
SQL query -and/ or condition in where clause
Adding some parenthesis and including OR conditions will get the results you are looking for.Answered | 3 Replies | 2383 Views | Created by sverreberre - Tuesday, March 6, 2012 2:12 PM | Last reply by Bruce Song - Monday, March 12, 2012 7:21 AM -
1 Votes
Condition in WHERE clause
WHERE Condition1 AND ((x=1 and Date between StartDate and EndDate) OR (x=2 and DateAnswered | 2 Replies | 776 Views | Created by Kalyan Alapati - Monday, September 12, 2016 8:39 PM | Last reply by FarhanAhmed-Xerva - Monday, September 12, 2016 8:50 PM -
0 Votes
How to use a condition in a WHERE clause ?
where dd.DateValue between @StartDate and @EndDate and ( (@RegionID = -1 AND r.ReportDMA in (1,2,4,5)) OR r.ReportDMA = @RegionID ...Answered | 3 Replies | 874 Views | Created by Developer life - Tuesday, September 2, 2014 6:47 PM | Last reply by Patrick Hurst - Tuesday, September 2, 2014 7:03 PM -
0 Votes
Using a if or Case in WHERE clause as second condition
Your conditions are logically: rows where code = E or rows where code in A ~ D and age between 0 and ...Answered | 1 Replies | 2717 Views | Created by Sedo5760 - Friday, July 12, 2013 11:52 AM | Last reply by scott_morris-ga - Friday, July 12, 2013 1:20 PM -
0 Votes
CASE statement/ conditional where clause
SELECT * FROM sys.tables T WHERE ( [Rule].Specialty = 'excld sss' AND Data.Location IN ( SELECT Location ...Answered | 4 Replies | 939 Views | Created by JasonDWilson77 - Wednesday, November 19, 2014 3:11 PM | Last reply by JasonDWilson77 - Wednesday, November 19, 2014 4:40 PM -
3 Votes
conditional where clause
To All: When offering WHERE predicate assistance, let's make sure that it is sargable.Answered | 8 Replies | 5894 Views | Created by markww - Friday, April 8, 2011 12:09 PM | Last reply by --CELKO-- - Friday, April 8, 2011 3:24 PM -
0 Votes
does it matter to sort conditions in the WHERE clause ?
There is an interesting blog by Brad Schulz that contradicts a theory that order of expressions in WHERE clause does not ...Answered | 3 Replies | 3084 Views | Created by Bassam, EG - Sunday, October 9, 2011 2:18 PM | Last reply by Naomi N - Sunday, October 9, 2011 5:03 PM -
0 Votes
Is it possible to use IF ELSE in the middle of WHERE Clause of StoredProcedure
10 AND BatchNo = @refNo) OR (@refNo <= 10 AND BatchNoAnswered | 4 Replies | 2309 Views | Created by SweNz - Wednesday, March 14, 2012 4:02 PM | Last reply by SweNz - Wednesday, March 14, 2012 4:54 PM -
0 Votes
Cast / convert in conditional where clause does not work
Giving us just the where clause can leave us guessing about what you want.Answered | 5 Replies | 754 Views | Created by HarmeetManocha - Saturday, March 3, 2018 6:49 PM | Last reply by HarmeetManocha - Thursday, April 5, 2018 9:59 PM -
0 Votes
Conditional Where clause - how to do this?
Hello, If you examine the function signature of Where, you will find that it takes a "predicate" of type "Expression<Func<T, bool>>", ...Answered | 1 Replies | 4689 Views | Created by PV66 - Thursday, September 24, 2009 6:34 PM | Last reply by Peter Qian - MSFT - Thursday, September 24, 2009 9:01 PM -
0 Votes
Variable length dynamic WHERE clause possible?
It may be possible to do this using dynamic sql.Answered | 2 Replies | 2720 Views | Created by PeterBDa - Monday, April 16, 2012 7:31 PM | Last reply by Jason A Long - Monday, April 16, 2012 7:39 PM -
0 Votes
Need help in where clause condition
As long as you have only two parameters, I would say conditional execution(with the help of if...else condition) is best considering the performance aspect.Answered | 2 Replies | 1555 Views | Created by Anil Kumar Devarapalem - Friday, September 27, 2013 10:17 AM | Last reply by SQLZealots - Friday, September 27, 2013 10:37 AM - Items 1 to 20 of 1636134 Next ›
No announcements
