Tolong pilih kategori sesuai, jenis posting (pertanyaan atau bukan) dan sertakan tag/topik yang sesuai misal komputer, php, mysql, dll.
Promosi atau posting tidak pada tempatnya akan kami hapus.
Mencantumkan kode program di posting Anda, tolong ikuti aturan yang sesuai, baca http://diskusiweb.com/discussion/39204/aturan-cara-menyisipkan-kode-program-di-diskusiweb

Baca cara posting gambar/image di post Anda: http://www.diskusiweb.com/discussion/47345/cara-menyisipkan-menyertakan-image-pada-posting/p1

query

Para Master saya minta penceran dengan garis yg telah saya tandai di query itu ap mksdnya kah  ?????????

Tanggapan

  • edited March 2013
    garis ?????????????????? query ???????????????????????????????????
  • wkwk.. itu betul. keren... waw..
    =P~


    lanjutkan !
  • n:D
    Maaf ke Delete tdi Gan.......:D


    declare
        @CaseType varchar(40),
        @StartDate datetime,
        @endDate datetime

    set @CaseType = 'InpatientLocal'
    set @StartDate = '2013-01-01'
    set @endDate = '2013-01-31'

    select
        b.PatientID as "NO. MR",
        c.PrePatientName as "Nama",
        a.CaseNo as "No. Kunjungan",
        a.CaseType as "Jenis Kunjungan",
        a.AdmissionTrndate as "Tgl. Daftar",
        a.AdmissionStatus as "Status",
        a.BedLocationID as "Lokasi",
        a.BedID as "Bed",
        isnull(f.InsuranceProviderName, 'PRIBADI'),
       
        c.PrePatientSmallName as "Small Name"

       

        --*

        from
            TrnAdmission as a
        left join Patient as b on
            a.BranchCode = b.BranchCode
        and a.PatientID = b.PatientID
        left join PrePatient as c on
            b.BranchCode = c.BranchCode
        and b.PraPatientID = c.PrePatientID
        left join CaseCaseReinsurance as d on
            a.BranchCode = d.BranchCode
        and a.CaseNo = d.CaseNo
        and a.AdmissionTrndate = d.AdmissionTrndate
        left join CaseReinsurance as e on
            d.BranchCode = e.BranchCode
        and d.CaseReinsuranceID = e.CaseReinsuranceID
        and e.InsuranceProviderID is not null
        left join InsuranceProvider as f on
            e.InsuranceProviderID = f.InsuranceProviderID
       
           
        where
       
            a.CaseType = @CaseType
        and CAST(convert(varchar, a.AdmissionTrndate, 102) as datetime) >= CAST(convert(varchar, @StartDate, 102) as datetime)
        and CAST(convert(varchar, a.AdmissionTrndate, 102) as datetime) <= CAST(convert(varchar, @endDate, 102) as datetime)
       
        order by
            a.AdmissionTrndate


    Maksud dari y " select
        b.PatientID as "NO. MR",
        c.PrePatientName as "Nama",
        a.CaseNo as "No. Kunjungan",
        a.CaseType as "Jenis Kunjungan",
        a.AdmissionTrndate as "Tgl. Daftar",
        a.AdmissionStatus as "Status",
        a.BedLocationID as "Lokasi",
        a.BedID as "Bed",
        isnull(f.InsuranceProviderName, 'PRIBADI'),
       
        c.PrePatientSmallName as "Small Name"

        "
         Tolong Pencerahannya gan ????? Terimakasih.
Sign In or Register to comment.