coba deh pake ini keterangannya sama dengan postingnya sinichi cuman disini pake case semoga membantu SELECT nama, case kode when 1 then 'HADIR' else 'ABSEN' end AS Absensi FROM DATAABSENSI
--- In [email protected], "Akhmad Aldi" <[EMAIL PROTECTED]> wrote: > > 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] >
