SELECT [status]
      ,[id_klaim]
      ,[id_dokumen_register]
      ,[deskripsi]
      ,[nama_pemegang]
      ,[nama_tertanggung]
      ,[no_polis]
      ,[tgl_mulai]
      ,[plan_dasar]
      ,[tgl_pengajuan]
      ,[tgl_masuk_rs]
      ,[hari_rawat]
      ,[id_diagnosa]
      ,[jenis_diagnosa]
      ,[total_diajukan]
      ,[total_dibayar]
      ,[total_ditolak]
      ,[total_potongan]
      ,[total_lunas]
      ,dbo.func_fixed_date([create_date]) AS 'create_date'
      ,[create_by]
      ,dbo.func_fixed_date([change_date]) AS 'change_date'
      ,[change_by]
      ,[otorisasi_date]
      ,[otorisasi_by]
      ,[unit_pelayanan_user]
  FROM [IndInsurance].[dbo].[view_Klaim]
WHERE otorisasi_by IN ('ELF','DUR','NIL','ISN') AND 
status IN ('I','M') AND 
otorisasi_date>='2012-10-01' AND otorisasi_date<='2012-12-31'
ORDER BY otorisasi_date

SELECT [otorisasi_by]
  FROM [IndInsurance].[dbo].[view_Klaim]
WHERE otorisasi_by IN ('ELF','DUR','NIL','ISN') AND 
--status='I' AND 
otorisasi_date>='2012-10-01' AND otorisasi_date<='2012-12-31'
GROUP BY otorisasi_by