No announcements
Found 3886370 threads
-
0 VotesCASE STATEMENT IN WHERE CLAUSE
" clause be eliminated?Answered | 8 Replies | 4358 Views | Created by GarinTiger - Monday, April 25, 2011 4:50 PM | Last reply by Hunchback - Monday, April 25, 2011 6:14 PM
-
0 Votes
conditional columns for each row
As the list of columns to be mentioned in the where clause are not predefined and dependent on some other table...Answered | 6 Replies | 2441 Views | Created by cololBIg - Monday, December 24, 2012 6:12 AM | Last reply by --CELKO-- - Monday, December 24, 2012 6:59 PM -
1 Votes
CASE statement in where Clause
Your Case statement will never work.Answered | 5 Replies | 1644 Views | Created by luizinyo - Tuesday, April 2, 2013 4:01 PM | Last reply by Naarasimha - Tuesday, April 2, 2013 5:02 PM -
2 Votes
When run batch sql statements, how get rows affected for each update statement?
when use SqlConnection.ExecuteReader() to run batch sql statements, It return the total rows affected for update statements.Answered | 5 Replies | 5154 Views | Created by Karry_Wong - Friday, May 24, 2013 8:30 AM | Last reply by Dan Guzman - Friday, May 24, 2013 11:23 AM -
3 Votes
Using Case statement in a Where clause
You cannot divide an IN clause like this.Answered | 2 Replies | 3282 Views | Created by Nagasayana Kuchibhotla - Wednesday, October 12, 2011 5:23 PM | Last reply by Arbi Baghdanian - Wednesday, October 12, 2011 5:27 PM -
1 Votes
order of columns in where clause
And approximately how many rows are in it?Answered | 34 Replies | 9462 Views | Created by nadirsql - Monday, June 27, 2011 12:48 AM | Last reply by Brad_Schulz - Tuesday, July 5, 2011 5:19 PM -
1 Votes
Using If statement in where clause
I tried your codes and my proyect is working very fine now, I guess I should use the one with fewer characters.Answered | 5 Replies | 20936 Views | Created by tonydeleons - Thursday, September 22, 2011 8:09 PM | Last reply by tonydeleons - Friday, September 23, 2011 8:29 PM -
3 Votes
Update statment with where exists clause
You also don't need to use NON MATCHED - each part of the MERGE statement is optional (but you need to have at least one of them).Answered | 5 Replies | 10674 Views | Created by NCooper - Wednesday, September 26, 2012 9:55 PM | Last reply by Naomi N - Thursday, September 27, 2012 4:35 PM -
1 Votes
Case statement in where clause
Naomi: How can I learn SQL like you?Answered | 4 Replies | 4398 Views | Created by KevinPat - Thursday, April 19, 2012 7:44 PM | Last reply by Naomi N - Thursday, April 19, 2012 8:19 PM -
0 Votes
CASE statement in where clause
Learn how to follow ISO-11179 data element naming conventions and formatting rules.Answered | 3 Replies | 1335 Views | Created by Sammy Williams - Sunday, August 24, 2014 12:41 PM | Last reply by --CELKO-- - Sunday, August 24, 2014 2:23 PM -
0 Votes
Case Statement in Where Clause
However, when you do it that way, the query optimizer will not be able to use any indexes or statistics you have on the Date1 and/or Date2 columns - that is, the query will ...Answered | 5 Replies | 4511 Views | Created by Mannu S - Wednesday, May 9, 2012 6:00 AM | Last reply by Tom Cooper - Wednesday, May 9, 2012 2:08 PM -
3 Votes
Case statement in where clause
As best I can tell, when the value of this parameter is <some uncertain but specific value> you want the report to select rows where STATUS = 'A'.Answered | 13 Replies | 1210 Views | Created by anishap456 - Wednesday, December 3, 2014 6:33 PM | Last reply by anishap456 - Wednesday, December 3, 2014 9:32 PM -
2 Votes
Update statement with FROM clause with multi joins
how the sql Update statement work , while using FROM Clause with multiple joins[also in this situation how the WHERE clause ...Answered | 6 Replies | 2057 Views | Created by anbu jeremiah - Tuesday, September 3, 2013 3:26 PM | Last reply by TiborK - Wednesday, September 4, 2013 8:46 AM -
0 Votes
Update statement with IN clause using a variable
And then use the select column_name from temp table in the IN clause.Answered | 9 Replies | 5356 Views | Created by Sax001 - Thursday, April 25, 2013 5:53 AM | Last reply by SQLZealots - Thursday, April 25, 2013 6:44 AM -
0 Votes
Case statement in Where Clause
When region_number is 16 or 17 then description has to have 'Use Corporate Email' in it But if region_number is anything else description doesn't have to have to that ...Answered | 6 Replies | 2078 Views | Created by R_i-c_h - Friday, November 16, 2012 8:16 PM | Last reply by R_i-c_h - Friday, November 16, 2012 9:07 PM -
0 Votes
where clause assistance
You can use statements like the above one.Answered | 3 Replies | 1234 Views | Created by SharePointGuy123 - Monday, March 25, 2013 3:03 PM | Last reply by Harsha Lella - Monday, March 25, 2013 7:32 PM -
0 Votes
CASE statement in a WHERE clause
But the OR is joining against either a non indexed small table with few rows, no rows or an empty variable.Answered | 12 Replies | 2656 Views | Created by ChrisTheDBA919 - Monday, April 16, 2012 2:51 PM | Last reply by Naomi N - Monday, April 16, 2012 4:28 PM -
0 Votes
How to dertermine what columns are are used in the where clause?
It will show you how SQL Server will process the query.Answered | 4 Replies | 3508 Views | Created by Suresh.Peddi - Sunday, October 23, 2011 5:23 PM | Last reply by Uri Dimant - Monday, October 24, 2011 7:31 AM -
0 Votes
Using CASE in the join statement in the AND clause.
Hi SqlCraze, we gon't use in two join between "And Case statement".Answered | 6 Replies | 1693 Views | Created by SqlCraze - Thursday, December 19, 2013 7:52 PM | Last reply by Chongtham Rajen Singh - Friday, December 20, 2013 7:41 AM -
1 Votes
Column Alias in Where clause
Standard SQL doesn't allow you to refer to a column alias in a WHERE clause.Answered | 7 Replies | 27625 Views | Created by almaverick - Wednesday, June 8, 2011 2:10 PM | Last reply by Kent Waldrop - Wednesday, June 8, 2011 2:24 PM - Items 1 to 20 of 3886370 Next ›
No announcements
