SQL Query to return 24 hour

SELECT CONVERT(VARCHAR(10),hd.Cleared_Date_Time,101) as dDate, CONVERT(VARCHAR(2),hd.Cleared_Date_Time,108) as TDate,
COUNT(hd.delivery_id) AS TotalHourlyTransactions
FROM hose_delivery hd , hoses h , grades g WITH (NOLOCK)
WHERE hd.hose_id = h.hose_id and h.grade_id = g.grade_id AND
hd.Cleared_Date_Time BETWEEN CAST('08-08-2012' AS SMALLDATETIME) AND CAST('09-08-2012' AS SMALLDATETIME)
GROUP BY CONVERT(VARCHAR(10),hd.Cleared_Date_Time,101), CONVERT(VARCHAR(2),hd.Cleared_Date_Time,108)
ORDER BY TDate ASC

Budak2 ni dah dpt Pengasuh baru.

Slps Yana nk kahwin Dan da x keje. Lps tu Sana indon yg pandai kelentong dah balik. Kemudian mak Mon pulk yg jaga, akhirye dpt jugk la Pengasuh utk budak2 ni.

<p>Kak ema nama dia. Budak2 ni panggil mak ema. Setelah sminggu hntr kt sana nmpkye ok lah. Alhmdllh. Mmg kt situ je lah, da x carik lain da smpi la pindh kt bangi nnti. </p>

Kn byr Rm480 sbln slps discount drpd hage asal Rm500. Lps tmbh lg Rm50 utk beli makann budak2 ni. Klu x kn bawak barang2 basah so fikir2 baik bg duit aje.

Hehe start hntr weekend lps. So Diorg nangis lah. Tp kejap je dlm 3 jam je then ambil. Hari Isnin budak2 ni kira Oklah x nangis dah tp muka Faiz sedih Sgt. Tp hari selasa dia da ok. Siap ckp suka sangat, suka sangat bila nk g sana :)

REDBAT for my putra for extra security

Putra aku ni da kena ompel kunci bonet belakang. X sangka pulk kereta lama camtu pun ada org nk curi.

Fikir2 decide beli lock ni lah. Hopefully mmg selamat la Dan senang nk lock. Kunci style klu Ssapa nk bukak mmg susah lah Dan makan masa lama.

Ok ni gmbr dia slps pasang. Dia ada 2 kunci Dan kereta x bole start klu kunci x bukak lg.

Hage dia siap pasang Rm290 beli kt kedai tinted d cheras. Pasang pd hari selasa lps.

Tq

New set tyre for my forte

Yesterday my forte got new set all tyre and the Total cost ngam2 tu 1k as follow
Newton N8000 215-45-17 : Rm240 x 4 = 960.00
Alignment : 20
Nozzle masuk angin : 4 x rm5 = 20

Decided to use the Newton tyre n8000 because of good review received from internet and from blog's friend.

The normal price of the tyre is rm280 but I ask them I got Rm240 price from blog and at last they give me the price.

Below is the receipt picture shooted later.

K5 versus Camry - word of cybermaster98

Copied from lowyat forumn write by cybermaster98. How good he's on writing and facts.

__________________

First of all, your parents are not old. Old would be in the 60 above bracket. U have to consider their lifestyle first. Are they gonna do alot of outstation driving or is it limited to just short dashes in the city? That would be your main consideration in getting a D segment. But if finance is not a problem for u, then by all means go ahead for a D segment. If not, then maybe best to go for something smaller. 

For now, uve brought your choices down to between the Camry and the Optima K5. And when u say 'price almost the same' i assume ure comparing the K5 with the 2.0 Camry (not sure if its E or G spec). 

Yes Kia has got many gadgets (most of it your parents wont use). But i note that ppl tend to focus more on gadgets which are merely add on's in my opinion. Before i bought the Optima, i checked out many D segment cars for many months. The following criteria helped in my decision making: 

1) Value for money - you get much more for the same price
2) Very good specs (not just add on's)
3) Cheaper price among the other D segments
4) Safety - marginally stronger body, more safety features
5) Great design
6) Spacious interior
7) Good fuel consumption
8) Best in class warranty terms (5 yrs unlimited mileage manufacturer's warranty) 

Safety features are not there to just compensate for your own mistakes. We may be great drivers but what happens when someone else makes a mistake (which is very common in Malaysia)? Therefore, the typical Malaysian mindset of 'no need extra airbags, no need VSC, no need ABS, etc' must change as even Paultan mentioned. We take our safety for granted too often. 

I owned a Toyota Vios for 9 years before i changed to the Optima. And i had a great experience with excellent after sales service. But later i realised that, i was getting ripped off by Toyota driving an 'empty' car but paying through my nose. No doubt i enjoyed 9 trouble free years but i was told that the later models had alot of problems. Over the 9 years, i got to know many of of the people at Toyota and thus was able to get inside information. Now u have the Camry coming out of Malaysia. Would the quality be as good as previous models? We'll have to wait and see i guess. 

Yes the Camry offers comfort which suits many people. Toyota's after sales service is good as well. But keep in mind that Kia is fast improving. Let me share an example. I found my Optima's rear suspension a bit soft when going over bumps at high speeds. I brought it up with Kia SC. They checked and found nothing wrong. But Kia Glenmarie (HQ) instructed them to just change the both rear shock absorbers FOC. I also complained about my driver's power window being a bit rough. And they changed the power window motor FOC. I would never have got this kind of service in Toyota. Toyota would have fought tooth & nail to defend themselves before making any change under warranty. But in saying this, Kia still has some way to go before they can truly say they are on par with the Japs. But i strongly believe they are on the right track. Their cars are now better and more technologically superior to many others. Their after sales are improving. Change takes time so dont expect anything overnight. 

Their sales are improving by leaps and bounds. Just look at the Forte in Malaysia. Its now a common sight already. Resale values are also much improved. When there is demand, resale values will increase. But remember that resale values for D segment cars cannot be compared to B & C segment cars. You will not get those kind of values. And right now, many of those going for the Camry are opting for the 2.5V with its new engine and gearbox. So ull find that in about 5 yrs time, the resale value (%) will be better for the 2.5V compared to the 2.0L. 

But since its for your parents, why bother about resale values anyway? Yes Toyota has made a name for itself building vehicles that are durable. But are the new models as durable? I have my reservations. But thats where warranty comes in. Kia has got among the best warranty terms in the market currently. 5 years unlimited mileage manufacturer's warranty. The 2nd best is VW and Peugeot with 3+2 years unlimited mileage. Even BMW only offers 4 years unlimited mileage. So if you have such good warranty terms from Kia, why not give the Optima a chance? 

But i think most importantly, is for your parents to drive both cars and have a feel. You can tell them the pro's and con's of each but ultimately they have to enjoy driving a particular make. But do educate them on the various aspects of the car. 

Personally, i am quite angry with Toyota for ripping off its customers here in Asia. The Camry was a real disappointment. Imagine still offering a 10 yr old gearbox and engine with a so called 'new generation' flagship car? If they can afford to fit out the American Camry with 10 airbags and VSC, why give us just 2 and remove the VSC as well? And still increase the price! Would they dare to do this in America? Surely not! That would have resulted in a nationwide boycott of the Camry. So why give them the chance to do it here? I truly believe that when the buying stops, only then will Toyota realise that they cant take Malaysians for granted anymore.

Just my 2 cents

Sony Xperia Sola - Tepon baru umi

Beli hage rm930 pada sabtu lepas. Set ori tuh
Beli kat the mines masa on the way nk balik kg tgk atuk salleh sakit.
Ok gak la tepon tu dgn hage dia.

Travel to Penang, Taiping and Kuala kangsar

X free lah nk tulis panjang2. So ringkas je lah.
Last weekend g penang jalan2 sempena umi cuti sekolah walupun sebenarya ke sana sbb nk pergi ke majlis perkahwinan kawan se-office Ijad. Seronok gak lah g sana dan plan akan pergi lagi sebab kat sana makan2 mmg byk yg popular punya kena pandai nk makan kat mana.

Tido 2 malam kat penang dan semalam kat taiping. First malam tido kat Hotel Sentral Georgetown and 2nd malam kat Nazza Talyya. Hotel Sentral puas hati kecuali parking susah sikit tp kat Nazza x syok lah. Sure last lah pegi situ. 3rd malam tido kat taiping hotel Flemington. Cantik gak lah hotel ni. Paling cantil swimming pool dia yg kat top sekali dan tepi dia dinding dia cermin saje.

Kat taiping x pegi mana2 pun kecuali g makan makan then singgah jap depan zoo taiping then terus g kuala kangsar. Kat sana apa lg, pegi lah kat center cendol kat pusat bandar tu. Lps tu bedesup balik KL.

Selain tu yg best nk cerita ialah pergi sana naik kereta Putra yg bertenaga NGV. Haha memang best sebab jimat. Mmg dpt jimat lebih kurang rm100 jugak la cost minyak sbb kami travel lebih dari 1000km.

Oklah nnti cerita lg kalau ada masa.