Tampilkan postingan dengan label scrip. Tampilkan semua postingan
Tampilkan postingan dengan label scrip. Tampilkan semua postingan
Rabu, 25 Januari 2012
Update subquery
update trmasterincentive set average_incentivenp=incentivenp
from trmasterincentive a
inner join (
select a.idstructure, incentive, cast(incentive*score as int) incentiveNP
from (
select idstructure, percentage, sum(incentive) incentive from _incentiveNPPercentage
group by idstructure, percentage
)a inner join trmasterincentive b on (a.idstructure=b.idstructure)
inner join mscore c on (status=10 and a.percentage between fromrange and torange)
) b on (a.idstructure=b.idstructure)
from trmasterincentive a
inner join (
select a.idstructure, incentive, cast(incentive*score as int) incentiveNP
from (
select idstructure, percentage, sum(incentive) incentive from _incentiveNPPercentage
group by idstructure, percentage
)a inner join trmasterincentive b on (a.idstructure=b.idstructure)
inner join mscore c on (status=10 and a.percentage between fromrange and torange)
) b on (a.idstructure=b.idstructure)
Selasa, 26 Juli 2011
Cek Mobile Browser
ini contoh script gwe lupa darimana untuk ngecek browser versi mobile....
http://www.ziddu.com/download/15826372/browser.txt.html
http://www.ziddu.com/download/15826372/browser.txt.html
Langganan:
Postingan (Atom)