oops...my bad ...sorry :blush:

seems that the sample data I created for you had some leading spaces in the columns !!

but doesnt this solution still give duplicates in "delivery method" and " contact method" ?

I thought...

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...

maybe not 😉

maybe useful to see the original exam question....just a thought

for example

SELECT

A

, B

FROM Table

WHERE (A IS NULL)

AND (B IS NOT NULL)

...

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...

sqlinterset (6/23/2015)

---

Actually ordering in ssms is being done through this way. But when i am pasting same query in excel pivot tables then this is giving data in normal order...

sqlinterset (6/22/2015)

---

I have a table has data of all months. i want to have this table data in the form as first it lists data

from 1 month to current...

LoudClear (6/22/2015)

---

Please show us your table, the data in it, and the results you want to see.

Better yet, give us the DDL for the table, INSERT statements for your data,...

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

well....I think the answer is 9 employees and you...

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...

jparks 85798 (6/18/2015)

---

Thanks for the suggestions. You are correct, looking back my sample data does not contain enough to illustrate what I am looking for. Let...

jparks 85798 (6/18/2015)

---

All,

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...