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]
