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.
Klik link berikut untuk informasi cara menyisipkan kode program supaya tampil rapi dan terformat dengan baik di diskusiweb.com: http://www.diskusiweb.com/discussion/50415/cara-menyisipkan-kode-program-di-diskusiweb-com

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  ?????????
Tagged:

Comments

  • 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.