quote:

---

Originally posted by kwacz23

Thank you for your response !!!

Is it posible to display only order where is only one vendor
I mean in the order you have only things from one order.

I my table there aren't these example. So query shouldn't give any result

Regards

---

DECLARE @Orders TABLE(Order_Number int, Order_line varchar(6), Vendor char(1))
INSERT INTO @Orders
SELECT 1, '1', 'A' union all
SELECT 1, '1.1', 'A' union all
SELECT 1, '1.2', 'A' union all
SELECT 1, '2', 'B' union all
SELECT 1, '3', 'C' union all
SELECT 2, '1', 'D' union all
SELECT 2, '1.1', 'D' union all
SELECT 3, '1', 'A' union all
SELECT 3, '1.1', 'A' union all
SELECT 3, '2', 'C'

SELECT * FROM @Orders 
WHERE Order_Number IN (SELECT Order_Number 
			FROM @Orders 
			GROUP BY Order_Number
			HAVING COUNT(distinct vendor) = 1

quote:

---

Originally posted by kwacz23

Thanks a lot !

---

SELECT *
FROM
(
SELECT *,
MAX(Vendor) OVER (PARTITION BY Order_number) AS MaxVendor,
,MIN(Vendor) OVER (PARTITION BY Order_number) AS MinVendor
FROM TAble
)t
Where MaxVendor = MinVendor