klo pake CASE gimana? (ada contohnya di Books Online) On 5/3/07, Akhmad Aldi <[EMAIL PROTECTED]> wrote: > > IIF ada juga ya di SQL Server?? > > On 5/3/07, Kudo, Shinichi <[EMAIL PROTECTED]> wrote: > > > > coba perintah ini. > > > > SELECT [nama], IIF([kode]=1,"HADIR","ABSEN") AS [Absensi] > > FROM [DATAABSENSI] > > > > ket : > > [nama] Field yg berisi A, B...E > > [kode] feld yg berisi 1 atau 0 > > > > [Absensi] Field temporary atau buatan > > > > para Suhu mohon CMIWW > > > > ----- Original Message ----- > > From: bl4ckpitbull > > To: [email protected] <indoprog-vb%40yahoogroups.com> > > Sent: Wednesday, May 02, 2007 8:05 PM > > Subject: [indoprog-vb] Tanya sql query > > > > Salam programmer. > > Saya ada pertanyaan. mohon bantuannya. terima kasih sebelumnya. > > ada data di database (sql) : > > > > select * from dataAbsensi > > hasilnya : > > A 1 > > B 0 > > C 1 > > D 1 > > E 0 > > > > yang saya mau hasilnya langsung ditampilkan > > A HADIR > > B ABSEN > > C HADIR > > D HADIR > > E ABSEN > > > > query nya gimana ya? > > Thanx sekali lagi. > > > > - Rudy - > > > > [Non-text portions of this message have been removed] > > > > > > > >
[Non-text portions of this message have been removed]
