مساعدة فى هذا الكود

قم بتغير هذا السطر

GROUP BY Client, Category

GROUP BY Client

Msg 8120, Level 16, State 1, Line 2
Column 'ALL_ProductSfO.Category' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

جرب هذا

SELECT Client,
CASE WHEN  Category ='sl' THEN   sum(Cartonex)END AS "ملح", 
CASE WHEN  Category='sh' THEN sum(Cartonex)END AS "سكر",
CASE WHEN  Category='ol' THEN sum(Cartonex)END AS "زيت",
CASE WHEN  Category='te' THEN sum(Cartonex)END AS "شاى"
from(
	SELECT 
			Client,   
			Category,
			Cartonex
	FROM 
			ALL_ProductSfO 
	WHERE 
			DATE='2016-03-01'
	) as x
GROUP BY Client
ORDER BY Client ASC;

KARIMSOFT كتب:

جرب هذا

SELECT Client,
CASE WHEN  Category ='sl' THEN   sum(Cartonex)END AS "ملح", 
CASE WHEN  Category='sh' THEN sum(Cartonex)END AS "سكر",
CASE WHEN  Category='ol' THEN sum(Cartonex)END AS "زيت",
CASE WHEN  Category='te' THEN sum(Cartonex)END AS "شاى"
from(
	SELECT 
			Client,   
			Category,
			Cartonex
	FROM 
			ALL_ProductSfO 
	WHERE 
			DATE='2016-03-01'
	) as x
GROUP BY Client
ORDER BY Client ASC;

لم يفلح اخى الكريم

Msg 8120, Level 16, State 1, Line 2
Column 'x.Category' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

نفس المشكلة وعند اضافة GROUP BY Client,Category

يظهر اسم العميل اكثر من مرة مع العلم انى اريد عدم تكرار العميل ووضع مسحوباته امامه.

اسف هذا هو الكود

SELECT Client,
sum(CASE WHEN  Category ='sl' THEN Cartonex else 0 END) AS "ملح",
sum(CASE WHEN  Category='sh' THEN Cartonex else 0 ENd) AS "سكر",
sum(CASE WHEN  Category='ol' THEN Cartonex else 0 END) AS "زيت",
sum(CASE WHEN  Category='te' THEN Cartonex else 0 END) AS "شاى"
from(
    SELECT
            Client,   
            Category,
            Cartonex
    FROM
            ALL_ProductSfO
    WHERE
            DATE='2016-03-01'
    ) as x
GROUP BY Client
ORDER BY Client ASC;

بارك الله فيك اخى الكريم ... دائما مبدع 

اكرمك الله