query sql server 2012 change to sql server 2008 - 


select  produksi.thntanam,         tanggal    (select  datepart(d,individualdate) tanggal,                  datepart(m,individualdate) bulan             daterange('d', '$tanggalawal', '$tanggalakhir')         ) daftartgl     inner join (select  b.thn_tanam thntanam,                         datepart(d,a.tgl_panen) tgl,                         datepart(m,a.tgl_panen) bln                    dbo.tp_produksi_pemanen                     left join tr_blok b on a.id_blok = b.id_blok                   a.nama_pemanen='" . $row['namapem'] . "' ,                         isnumeric(a.nik_pemanen ) = 1 ,                         a.id_satuan_unit_afd ='" . $id_afd . "'                   group b.thn_tanam, datepart(d,a.tgl_panen), datepart(m,a.tgl_panen)                ) produksi on daftartgl.tanggal = produksi.tgl , daftartgl.bulan = produksi.bln";

this question in sql server 2012 , want use code in sql server 2008

but not work

can me change sql server 2008 ??


-

Comments

Post a Comment

Popular posts from this blog

java - AEM: 403 Forbidden occurs when call a Post servlet -

my problem similar this: cq5: 403 forbidden occurs when call post servlet in aem 6.1 according accepted answer of above topic, must remove post apache sling referrer filter. wonder if action harmful system? , have better way fix issue? p/s: sorry english. if testing code on author mode, 403 forbidden error request. requires csrf token. or can declare dependency granite.csrf.standalone before can use framework. on publish should work fine.
Read more

ruby on rails - ActiveRecord order not working -

in controller, after reprioritizing "child", lists children in new order: @child.parent.children.sort_by{|g| g.priority } this, surprisingly, doesn't work: @child.parent.children.order(priority: :asc) why doesn't .order work? instead of sorting correctly, it's sorting previous order before operation run, assume it's using cached results (the query run before in operation). how 1 bust cache, if indeed problem? i've tried @child.reload after reprioritizing no avail. if have ordering on children association might try use reorder apply new ordering: @child.parent.children.reorder(priority: :asc)
Read more

Google Alert - facebook

News 13 new results for facebook   Researcher: Facebook Ignored The Bug I Found Until I Used It To Hack ... San Francisco Chronicle Facebook has a bounty program where it pays people to report bugs instead of using them or selling them on the black market. In this case, instead of fixing the bug and paying the researcher the $500+ fee, Facebook told him "this was not a bug ... See all stories on this topic » Facebook tip leads to arrest in Cal riot vandalism San Jose Mercury News Updated: 08/18/2013 11:00:17 AM PDT. HUNTINGTON BEACH, Calif.—Authorities in a Southern California beach community tracked down a suspected vandal after police say he "liked" photos of damaged patrol cars on the department's Facebook page. See all stories on this topic » Facebook tests tool for mobile payments Sky News Australia Facebook plans to test a new service aimed at making it easier for users to make purchases on their mobile devices. The social networking sit...
Read more