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

How to use SUM() in MySQL for calculated values -

in mysql, dont know how use function sum calculated values. could me please? in code below, latest part. thing want add row @ end, summarizing "calculado" column thank in advance select p.id_order ref, concat (di.firstname,' ',di.lastname) nombre, ca.weight peso, if (ca.weight<1,(1), if (ca.weight>=1 , (ca.weight<3),(2), if (ca.weight>=3 , (ca.weight<5),(3), if (ca.weight>=5 , (ca.weight<8),(4), if (ca.weight>=8 , (ca.weight<10),(5), if (ca.weight>=10 , (ca.weight<15),(6), if (ca.weight>=15 , (ca.weight<20),(7), if (ca.weight>=20,(ca.weight*(0.5)),'error' )))))))) calculado, p.invoice_date fecha ps_orders p left join ps_address di on (p.id_address_delivery = di.id_address) left join ps_order_carrier ca on (p.id_order = ca.id_order) date(p.invoice_date) >= concat(date_format(last_day(now...
Read more

loops - Spock: How to use test data with @Stepwise -

i used @stepwise automation. 8 test methods running sequentially complete process. 1 of methods take parameter , want pass different parameters method. but problem is: method takes first set of parameter, parameters processed and instead of proceeding next method, method takes next set of parameter. the source looks like: @stepwise class aosearchpagetest extends gebreportingspec { def "first_method"() { } def "second_method"() { when: @ particularpage then: process(area) process(coutntry) process(airport) process(dest_area) process(dest_coutntry) process(dest_airport) where: area << ["asia","europe"] country << ["japan","uk"] port << ["narita","london"] dest_area << ["asia","europe"] dest_country << ["k...
Read more