----- Original Message ----- From: "garudamas" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, December 08, 2005 4:24 PM Subject: [indoprog-vb] insert
> 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 > > > > > 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 > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/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/
