ساده ترین حالت :
SELECT * FROM
(SELECT name,code,mande FROM TableName) AS Source
PIVOT (SUM(mande) FOR code IN ([1],[2],[3],[4],[5],[6])) AS Result
ساده ترین حالت :
SELECT * FROM
(SELECT name,code,mande FROM TableName) AS Source
PIVOT (SUM(mande) FOR code IN ([1],[2],[3],[4],[5],[6])) AS Result
قوانین ایجاد تاپیک در تالار
پاسخ با نقل قول