No announcements
Found 1137108 threads
-
3 Voteswhere clause
For best practice, most programmers use the ON condition to specify how rows in one table are matched to rows in the other table (in this case, it's when the id columns are equal) ...Answered | 3 Replies | 905 Views | Created by Vaishu - Wednesday, October 14, 2015 3:34 PM | Last reply by Tom Cooper - Wednesday, October 14, 2015 5:20 PM
-
6 Votes
Difference between Join in FROM clause and WHERE clause
If J M's example were an INNER JOIN, then I would expect identical execution plans (and performance) between the JOIN and WHERE clause queries.Answered | 6 Replies | 12111 Views | Created by r_u_j_u - Wednesday, March 10, 2010 12:38 PM | Last reply by Dan Guzman - Saturday, March 13, 2010 3:20 PM -
1 Votes
where clause and on clause
FROM ON JOIN WHERE GROUP BY WITH CUBE or WITH ROLLUP HAVING SELECT DISTINCT ORDER BY TOP Jon RoyalesAnswered | 3 Replies | 5004 Views | Created by Rajendra _ - Monday, April 12, 2010 11:28 AM | Last reply by Naomi N - Monday, April 12, 2010 1:49 PM -
0 Votes
Where clause
ValidateDateTime and then you ran Declare @date date = '2015-02-12' Select * from table1 where ValidateDateTime >@Date ...Answered | 2 Replies | 903 Views | Created by Vaishu - Tuesday, August 11, 2015 1:58 PM | Last reply by Berimi - Tuesday, August 11, 2015 2:08 PM -
0 Votes
where clause
Both of them are crap and you have no table in the FROM clause.Answered | 10 Replies | 1211 Views | Created by Skuragayala - Friday, December 26, 2014 9:59 PM | Last reply by Erland Sommarskog - Saturday, December 27, 2014 9:09 PM -
0 Votes
Where Clause
first you should check datatype if it's right then try to use between clause on date function.Answered | 3 Replies | 862 Views | Created by tpeek1964 - Wednesday, March 11, 2015 6:12 AM | Last reply by tusharshinde - Wednesday, March 11, 2015 6:28 AM -
0 Votes
where clause
In dataflow task when converting a .csv file to a sql server table, what task do you use to use where clause?Answered | 2 Replies | 4257 Views | Created by arkiboys - Monday, October 26, 2009 1:42 PM | Last reply by arkiboys - Monday, October 26, 2009 9:12 PM -
0 Votes
Is this conditional WHERE clause possible?
" clauses within my WHERE clause?Answered | 4 Replies | 1494 Views | Created by Pelalusa - Saturday, September 27, 2014 2:03 AM | Last reply by --CELKO-- - Saturday, September 27, 2014 5:01 PM -
2 Votes
WHERE clause
Putting the condition from WHERE to the join ON condition is correct.Answered | 2 Replies | 1487 Views | Created by mikelvfp - Monday, October 15, 2012 4:28 AM | Last reply by mikelvfp - Monday, October 15, 2012 2:44 PM -
8 Votes
The mechanics of the WHERE clause
The WHERE clause is applied to the working set in the FROM clause.Answered | 15 Replies | 9098 Views | Created by falcon00 - Monday, May 6, 2013 4:29 PM | Last reply by sganeshanexeter - Friday, February 20, 2015 7:18 AM -
1 Votes
Case When in where clause
DECLARE @Site VARCHAR(20) SET @Site = 'C001' SELECT * FROM Site WHERE (@Site = 'C001' AND Site IN('C001A','C001B')) OR (@Site !Answered | 2 Replies | 4923 Views | Created by Fazlu - Friday, November 12, 2010 3:14 PM | Last reply by Justanewone - Friday, November 12, 2010 3:26 PM -
0 Votes
CASE STATEMENT IN WHERE CLAUSE
Hunchback - If DisbursementCode is NULL, your clause will never evaluate to TRUE.Answered | 8 Replies | 4341 Views | Created by GarinTiger - Monday, April 25, 2011 4:50 PM | Last reply by Hunchback - Monday, April 25, 2011 6:14 PM -
0 Votes
Union ALL where clause
Hi, You can add a Conditonal Split to your dataflow - this has the same affect as a WHERE clause in SQL.Answered | 1 Replies | 5779 Views | Created by cat_ca - Monday, March 1, 2010 8:18 PM | Last reply by Jamie Thomson - Monday, March 1, 2010 8:53 PM -
0 Votes
where clause evaluation in mdx
Hi, What kind of query do you have in mind where the order of evaluation within the WHERE clause matters?Answered | 3 Replies | 5967 Views | Created by Ramu Sql - Wednesday, November 11, 2009 2:04 PM | Last reply by AshokDugaputi - Thursday, November 12, 2009 12:26 PM -
1 Votes
using case in where clause
HI There your wheer clause need to be like this not as you have posted above WHERE myattribute=case when @present='present' ...Answered | 5 Replies | 3320 Views | Created by somya12 - Wednesday, May 23, 2012 6:41 PM | Last reply by Syed Qazafi Anjum - Wednesday, May 23, 2012 8:59 PM -
1 Votes
where clause question
Hi Good question I need to add it to my SQL Where clause tutorial.Answered | 3 Replies | 2490 Views | Created by sqlguy10 - Saturday, May 19, 2012 2:54 PM | Last reply by Katie and Emil - Saturday, May 19, 2012 8:33 PM -
1 Votes
order of columns in where clause
that being said, there is one example of a case where the order of the predicates in a WHERE clause DOES matter.Answered | 34 Replies | 9446 Views | Created by nadirsql - Monday, June 27, 2011 12:48 AM | Last reply by Brad_Schulz - Tuesday, July 5, 2011 5:19 PM -
4 Votes
From and Where clauses
Ex: SELECT * FROM Ages -- returns all data from the table SELECT Name FROM Ages --returns the names ...Answered | 4 Replies | 4082 Views | Created by Ajaykumar Muchakurthi - Friday, April 20, 2012 1:39 AM | Last reply by Samuel Lester - MSFT - Friday, April 20, 2012 3:37 AM -
1 Votes
CASE statement in where Clause
= (DATEADD(d, DATEDIFF(d, 0, GETDATE()), 0)) AND name='someothervalue' NarsimhaAnswered | 5 Replies | 1629 Views | Created by luizinyo - Tuesday, April 2, 2013 4:01 PM | Last reply by Naarasimha - Tuesday, April 2, 2013 5:02 PM -
0 Votes
join/where clause
Hi arkiboys, For inner join, they mean the same thing, it doesn't matter to put the condition in WHERE or ON clause.Answered | 4 Replies | 1192 Views | Created by arkiboys - Saturday, April 11, 2020 1:06 PM | Last reply by arkiboys - Monday, April 13, 2020 7:07 AM - Items 1 to 20 of 1137108 Next ›
No announcements
