To : TIA
Salam Kenal,
Kalau tidak salah untuk expresi CASE di SQL format sintaxnya seperti dibawah
ini :
CASE input_expression
WHEN when_expression THEN result_expression
[ ...n ]
[
ELSE else_result_expression
]
END
Saya sudah coba Query Saudara di SQL Query Analyzer dan error
----- Original Message -----
From: vbPian
To: [email protected]
Sent: Thursday, February 15, 2007 9:12 AM
Subject: RE: [Programmer-VB] Query Summary
Bung Rony apa bisa juga kodenya seperti ini ?
SELECT Item,
CASE MONTH(Tanggal)=1 THEN SUM(Harga) ELSE 0 END AS Jan,
CASE MONTH(Tanggal)=2 THEN SUM(Harga) ELSE 0 END AS Feb,
CASE MONTH(Tanggal)=3 THEN SUM(Harga) ELSE 0 END AS Mar
FROM ...
TIA,
[zZzz]
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of
Rony Wijaya
Sent: Wednesday, February 14, 2007 5:16 PM
To: [email protected]
Subject: Re: [Programmer-VB] Query Summary
Coba dengan memakai pivot dari SQL
cth : utk mendapatkan data ini
Year Q1 Q2 Q3 Q4
1990 1.1 1.2 1.3 1.4
1991 2.1 2.2 2.3 2.4
maka querynya sebagai berikut :
SELECT Year,
SUM(CASE Quarter WHEN 1 THEN Amount ELSE 0 END) AS Q1,
SUM(CASE Quarter WHEN 2 THEN Amount ELSE 0 END) AS Q2,
SUM(CASE Quarter WHEN 3 THEN Amount ELSE 0 END) AS Q3,
SUM(CASE Quarter WHEN 4 THEN Amount ELSE 0 END) AS Q4
FROM Northwind.dbo.Pivot
GROUP BY Year
maka kalau untuk kondisi saudara Liung sebagai berikut :
SELECT Item,
SUM(CASE Harga WHEN MONTH(Tanggal)=1 THEN Harga ELSE 0 END ) AS Jan,
SUM(CASE Harga WHEN MONTH(Tanggal)=2 THEN Harga ELSE 0 END) AS Feb,
SUM(CASE Harga WHEN MONTH(Tanggal)=3 THEN Harga ELSE 0 END) AS Mar,
.
.
.
FROM NamaTable
GROUP BY Item
Coba aja domodifikasi sedikit, Semoga bisa membantu
----- Original Message -----
From: Liung Hartono
To: milis - Programmer-VB
Sent: Wednesday, February 14, 2007 3:02 PM
Subject: [Programmer-VB] Query Summary
Halo,
saya ingin mendapatkan data summary data tapi menyamping ada yang tahu
caranya nggak ya ?
Jadi data saya begini :
Tanggal Item Harga
Query yang saya ingin dapatkan adalah :
Item Jan Feb Mar dst..
Thanks sebelumnya
Liung's
www.apktntajd.com (Ape Kate Ente Aje Deh!)
