Irfani Firdausy Live Journal

Random header image... Refresh for more!

Kumpulan Query

 


 

kumpulan query-query di mssql server dalam rangka membangun Retail Banking Direktorat Portal, cuman mengingat saja kali aja ntar lupa :d :

select convert(varchar(11),date_curr) as tglhigh,tglymd from fund_highlt where flag in (3,9) order by date_curr desc

select * from fund_highlt where flag in (3,9) and tglymd=’20111220′

select TOP 1 tglymd from fund_highlt order by hid desc

declare @maxhid int set @maxhid = (select max(hid) from fund_highlt) select totdpk,volGiro,volTab,volCASA,vol_depo,vol_flex,volTD,tglymd,flag from fund_highlt
where (hid>@maxhid-5 and hid<=@maxhid) or flag=1 order by tglymd

[Read more →]

December 29, 2011   3 Comments

Blue Man Group – Up To the Roof

Konser Blueman melibatkan aneka macam musik, semangatt

[Read more →]

November 17, 2011   No Comments

Pengajian Ramadhan hari ke-4 2011

Hari ini Kamis tanggal 4 agustus 2011 di bulan ramadhan 1432H tepat jam 12 siang, seperti biasa saya turun dari lantai 21 ke lantai 3 ingin sholat dhuhur dan mendengarkan ceramah ramadhan di auditorium Menara Bank Mega.

[Read more →]

August 4, 2011   1 Comment

How to Hotlink-protect images using .htaccess

If your running apache server, you can do what you need by configuring your .htaccess file.

You would do something like this to prevent hotlinking of images -

RewriteEngine on
RewriteCond %{HTTP_REFERER}!^$
RewriteCond %{HTTP_REFERER}!^http://(www\.)?mydomain.com/.*$ [NC]
RewriteRule \.(gif¦jpg¦js¦css)$ – [F]

replace mydomain.com with your domain name and only your domain will be allowed to access files appeneded by .gif .jpg .js or .css

you can add other allowed domaine with extra lines e.g. -

RewriteEngine on
RewriteCond %{HTTP_REFERER}!^$
RewriteCond %{HTTP_REFERER}!^http://(www\.)?mydomain.com/.*$ [NC]
RewriteCond %{HTTP_REFERER}!^http://(www\.)?domain1.com/.*$ [NC]
RewriteCond %{HTTP_REFERER}!^http://(www\.)?domain2.com/.*$ [NC]
RewriteCond %{HTTP_REFERER}!^http://(www\.)?domain3.com/.*$ [NC]
RewriteRule \.(gif¦jpg¦js¦css)$ – [F]

October 5, 2009   No Comments

Makanan Penurun Kolesterol

Gaya hidup merupakan salah satu faktor risiko penyebab kolesterol yang dapat diubah. Salah satu perubahan gaya hidup yang mudah dilakukan adalah dengan memilih konsumsi makanan yang tepat.

Ada beberapa jenis makanan yang efektif meningkatkan kolesterol baik (high-density lipoproteins/HDL). HDL berfungsi membuang kelebihan kolesterol dari sel dan dinding arteri serta membawa kolesterol kembali ke hati untuk dibuang. Oleh karena itu, dibutuhkan kesadaran sejak dini untuk mulai memilih-milih makanan yang sehat dikonsumsi.

[Read more →]

August 19, 2009   No Comments

101 Great Computer Programming Quotes

“People always fear change. People feared electricity when it was invented, didn’t they? People feared coal, they feared gas-powered engines. There will always be ignorance, and ignorance leads to fear. But with time, people will come to accept their silicon masters.”

As Bill Gates once warned, computers have indeed become our silicon masters, pervading nearly every aspect of our modern lives. As a result, some of the greatest minds of our time have pondered the significance of computers and software on the human condition. Following are 101 great quotes about computers, with an emphasis on programming, since after all this is a software development site.
Computers

[Read more →]

August 7, 2009   1 Comment

Obat Puyeng barang 2 menit

T : Kalau Asterix habis kerja berat dan capek sekali, jadinya apa ?
J : Pegel Linux
T : Monyet apa yang berdiri di tepi jalan ?
J : Monyetop angkot
T : Kota apa yang nilainya selalu tujuh ?
J : Salatiga, kalau saladua nilainya delapan
T : Kentang apa yang dingin ?
J : Kentangkuban perahu malam-malam
T : Tukang apa yang kalo dipanggil nengok ke atas ?
J : Tukang gali sumur
T : BMW apanya yang mahal ?
J : W-nya, soalnya kalo diganti X jadi murah
T : Saya punya uang Rp 150, terus saya beli permen Rp 75, berapa kembalinya
?
J : Kembalinya Rp 25, karena bayarnya pake uang ce’pe’an.
T : Apa bedanya bulan sama matahari ?
J : Kalau Matahari banyak discount, kalo bulan belum pernah ke sana tuh
T : Di rambut ada, dikening ngga ada, di hidung ada, di alis ngga ada, di
mulut ada, di mata dan pipi ngga ada, apakah itu ?
J : Huruf U
[Read more →]

July 31, 2009   No Comments

SEO Primer – 7 Basics of SEO

Article printed from SEO-News: http://www.seo-news.com
HTML version available at: http://www.seo-news.com/archives.html

SEO Primer – 7 Basics of SEO
By George Peirson (c) 2009

We are going to look at 7 Basics of SEO below. These aren’t the
only things you want to know about SEO, but are the areas you
should learn first. Some topics will only take you a minute,
some will take a little longer, and others will become an
ongoing process. But after reading through this list you should
have a good handle on where to start and where to proceed next.
[Read more →]

April 10, 2009   No Comments

State of the Web 2008

January 17, 2009   No Comments

Shalat Istikharah

Shalat Istikharah
Dari Wikipedia bahasa Indonesia, ensiklopedia bebas
Shalat Istikharah adalah shalat sunnat yang dikerjakan untuk meminta petunjuk Allah oleh mereka yang berada diantara beberapa pilihan dan merasa ragu-ragu untuk memilih. Spektrum masalah dalam hal ini tidak dibatasi. Seseorang dapat shalat istikharah untuk menentukan dimana ia kuliah, siapa yang lebih cocok menjadi jodohnya atau perusahaan mana yang lebih baik ia pilih. Setelah shalat istikharah, maka dengan ijin Allah pelaku akan diberi kemantapan hati dalam memilih.

[Read more →]

January 1, 2009   No Comments