Viewing 15 posts - 1,201 through 1,215 (of 2,452 total)
oops...my bad ...sorry :blush:
seems that the sample data I created for you had some leading spaces in the columns !!
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 26, 2015 at 3:21 am
jbalbo (6/25/2015)
Thanks imex,That worked exactly as I needed.
Sorry for the bad explanation..
Thanks AGain
but doesnt this solution still give duplicates in "delivery method" and " contact method" ?
I thought...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2015 at 10:21 am
seems this is your second post on this subject.....you will probably get a better response if you provide the required create table / insert data statement that provide a readily...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2015 at 8:19 am
J Livingston SQL (6/24/2015)
ve got this problem with this exercise
maybe useful to see the original exam question....just a thought
maybe not 😉
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2015 at 10:28 am
ve got this problem with this exercise
maybe useful to see the original exam question....just a thought
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2015 at 9:57 am
for example
SELECT
A
, B
FROM Table
WHERE (A IS NULL)
AND (B IS NOT NULL)
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 23, 2015 at 2:43 pm
sqlinterset (6/23/2015)
Please see attachement
what version of excel are you using?
in 2013 you can manually move rows to sort your requirements
and to echo others...without a YEAR this may prove troublesome for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 23, 2015 at 11:36 am
sqlinterset (6/23/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 23, 2015 at 11:02 am
sqlinterset (6/22/2015)
from 1 month to current...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 22, 2015 at 2:55 pm
LoudClear (6/22/2015)
Better yet, give us the DDL for the table, INSERT statements for your data,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 22, 2015 at 2:46 pm
does this make any sense to you........
SELECT distinct O.EmployeeID
FROM Orders O
WHERE O.OrderDate BETWEEN '1998-01-01' AND GETDATE()
SELECT distinct O.EmployeeID
FROM Orders O
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 21, 2015 at 2:54 pm
Eric_Shao (6/21/2015)
Hi SS,Thanks for your answer, but the question ask specifically to use right join and sub query to solve the problem:-)
well....I think the answer is 9 employees and you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 21, 2015 at 1:46 pm
see if this helps.......as I read your homework, the question relates to employees not number of orders
SELECT
O.EmployeeID
, E.FirstName + ' ' + E.LastName AS Fullanme
FROM Orders...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 21, 2015 at 5:54 am
jparks 85798 (6/18/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 18, 2015 at 9:54 am
jparks 85798 (6/18/2015)
My first post here and i'm still relatively new to t-sql. I have searched around and I am completely stuck on where to even start. I am using...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 18, 2015 at 9:36 am
Viewing 15 posts - 1,201 through 1,215 (of 2,452 total)