mungkin ada yang bisa bantu kalau connec pakai acces saya selalu pakai di
bawah ini tapi pindah ke sql server muncul binary data be truncated. kalau
nggak pakai insert bisa tampil data. kira2 cara pakai insert di sql server
gimana ya.
msql = "insert into gabung select parts.kode, parts.Nama, parts.cat,
parts.jenis, parts.awalq, parts.awalh, " & _
" (select sum(qty) from kredit where tglkredit>='" &
Format(dpDr.Value, "MM/DD/YYYY") & "' and tglkredit<='" &
Format(dpSp.Value, "MM/DD/yyyy") & "' group by kredit.kode
having(kredit.kode=parts.kode)) as krQty, " & _
" (select sum(qty*harga) from kredit where tglkredit>='" &
Format(dpDr.Value, "MM/DD/YYYY") & "' and tglkredit<='" &
Format(dpSp.Value, "MM/DD/yyyy") & "' group by kredit.kode
having(kredit.kode=parts.kode)) as krHarga, " & _
" (select sum(qty) from masuk where tglmasuk>='" & Format(dpDr.Value,
"MM/DD/YYYY") & "' and tglmasuk<='" & Format(dpSp.Value, "MM/DD/yyyy") & "'
group by masuk.kode having(masuk.kode=parts.kode)) as mQty, " & _
" (select sum(qty*harga) from masuk where tglmasuk>='" &
Format(dpDr.Value, "MM/DD/YYYY") & "' and tglmasuk<='" & Format(dpSp.Value,
"MM/DD/yyyy") & "' group by masuk.kode having(masuk.kode=parts.kode)) as
mharga, " & _
" (select sum(qty) from keluar where tglkeluar>='" &
Format(dpDr.Value, "MM/DD/YYYY") & "' and tglkeluar<='" &
Format(dpSp.Value, "MM/DD/yyyy") & "' group by keluar.kode
having(keluar.kode=parts.kode)) as kQty, " & _
" (select sum(qty*harga) from keluar where tglkeluar>='" &
Format(dpDr.Value, "MM/DD/YYYY") & "' and tglkeluar<='" &
Format(dpSp.Value, "MM/DD/yyyy") & "' group by keluar.kode
having(keluar.kode=parts.kode)) as kharga " & _
" from parts order by parts.kode"
thank's
------------------------ Yahoo! Groups Sponsor --------------------~-->
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/zCsqlB/TM
--------------------------------------------------------------------~->
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-vb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
