Post by Goborijung at 2019-12-13 14:30:09 | ID: 316
/* การใช้ CASE สำหรับเงื่อนไขตามตรรกะ */ SELECT CONo, SUM(CASE WHEN MONTH(ETADate) = 1 THEN ORDQTYPCS ELSE 0 END) AS [1-Jan], SUM(CASE WHEN MONTH(ETADate) = 2 THEN ORDQTYPCS ELSE 0 END) AS [2-Feb], SUM(CASE WHEN MONTH(ETADate) = 3 THEN ORDQTYPCS ELSE 0 END) AS [3-Mar], SUM(CASE WHEN MONTH(ETADate) = 4 THEN ORDQTYPCS ELSE 0 END) AS [4-Apr], SUM(CASE WHEN MONTH(ETADate) = 5 THEN ORDQTYPCS ELSE 0 END) AS [5-May], SUM(CASE WHEN MONTH(ETADate) = 6 THEN ORDQTYPCS ELSE 0 END) AS [6-Jun], SUM(CASE WHEN MONTH(ETADate) = 7 THEN ORDQTYPCS ELSE 0 END) AS [7-Jul], SUM(CASE WHEN MONTH(ETADate) = 8 THEN ORDQTYPCS ELSE 0 END) AS [8-Aug], SUM(CASE WHEN MONTH(ETADate) = 9 THEN ORDQTYPCS ELSE 0 END) AS [9-Sep], SUM(CASE WHEN MONTH(ETADate) = 10 THEN ORDQTYPCS ELSE 0 END) AS [10-Oct], SUM(CASE WHEN MONTH(ETADate) = 11 THEN ORDQTYPCS ELSE 0 END) AS [11-Nov], SUM(CASE WHEN MONTH(ETADate) = 12 THEN ORDQTYPCS ELSE 0 END) AS [12-Dec], -- SUM(ORDQTYPCS) AS Total FORMAT(SUM(ORDQTYPCS),'#,##0.00') AS Total FROM TM_SO WHERE YEAR(ETADate) = 2018 GROUP BY CONo ORDER BY CONo
Post by Goborijung at 2019-10-06 16:05:13 | ID: 147
>> เวอร์ชัน รุ่น และระดับการอัปเดต SQL Server https://support.microsoft.com/th-th/help/321185/how-to-determine-the-version-edition-and-update-level-of-sql-server-an
Post by Goborijung at 2019-12-13 16:15:00 | ID: 317
/* การเรียกดู User Define Function ที่เราได้สร้างไว้ */ SELECT o.name,o.type_desc,s.definition FROM sys.sql_modules AS s INNER JOIN sys.objects AS o ON s.object_id = o.object_id WHERE o.type IN ('IF','TF','FN') ORDER BY name
Post by Goborijung at 2020-01-18 12:48:06 | ID: 368
สอน Microsoft SQL Server