If you are working at Golden Triangle and would like to find out your latest EPF, you can go to RHB bank at KLCC. There, there is a EPF kiosk machine just right on your right side after the main entrance. Just follow the simple instruction from the machine and you will be asked to put your thumb on the machine for verification. Once done, the machine will print out the latest statement of your EPF. You can also choose which year you would like to print out. I think that’s pretty cool.
Football / futsall is one of my favorites sports. I started soccer during my primary school. From primary school until college time, I always as a defender and occasionally goalkeeper. Few years ago, I began to like to play middle / forward position. I began to enjoy dribbling. That time, I began to get serious about soccer. I read many articles to learn the proper technique and skill and I trained myself. Throughout my ten years as a member of Central Christian Church of Malaysia, my church has organized a few soccer competitions and I joined all of them. Even though I like to play to middle or forward position, but because lack of strong defenders, I need to stay back to strengthen the defensive teritory most of the time. but because of my position,
Goal!
I hardly score any goals during all the soccer competition matches I participated in my entire life. I just manage to score two goals (what I can remember) during all these competitions and both goals are long ranged one. That time, I consider my freekick or long distance shot is not bad. I believe that is because I practice it. But now, I koyak liao. 😀
Futsal
Lately, I have changed to play futsal (indoor soccer). Some of my church members orgnized the first futsal competition end of last year (2007). I participated. Well, my team lost just at the very last minute but we had a good fight. We shall be back! 😀
Now
Now, sometimes I will play futsal on Sunday afternoon at the place just opposite Global Business Park, where we have our church service in the morning. Lately, I also enjoy juggling as well, to exercise, for fun and to train myself too. Although not that impressive yet, below is a little clip of some juggling I did on July 2008.
May and June’s Update
Some same old update thing from me. For May, my attendance is 69% (miss four times) and for June is 85% (miss twice). Looks like May is the worst month at the moment. Anyway, just to update you guys that I’m still on. I think the one big thing I hope to ‘fix’ is my fat tummy. Not sure why it has gotten big. Maybe I eat too much nasi lemak and drink much milo (two cups a day recently). Right now, my weight, it is still hanging in between around 56.5 kg. What I should gain is muscles, not fat. Hehe…
Beware of Thief
Last Monday, 30 June 2008, I lost my watch in Men’s Changing Room. Well, I believe it was stolen. What happen is that time I was weighing myself. Because I want to have more accurate measurement, I took out as many thing from me as possible. So, I took out my watch and my locker keys and put them down on the floor, together with other things like my water bottle, pen, writing pad and a pair of shoes.
Then, I went to the basin, which is just besides the weighing scale, to wash my hands. Then, I went back to grab all my stuff and quickly go to my locker and then to changing room to changing. Only when I was changing, I realize that my watch was there! I went back, it wasn’t there.
Actually, I have already heard that there are lockers got unlocked by thief and I know that I shouldn’t put my watch on the floor just like that. In fact, this is the first time I did that. I thought, “Aiya, I am sure won’t get it one lah. So short time. How can it possible?”. Well, my foolishness and naiveness paid the price.
Though it was not too expensive, but I felt the pinch of it. I like my watch. I rely on it a lot. But, no matter how I felt, I won’t able to get it back. I just need to learn from the lesson. So, if you are a California Fitness member as well, beware of thief. They are out there and they are quick as well. Don’t look down or take it for granted, even five seconds. They can get it done in less that, easily, I believe.
Let’s try this out. First, open your SQL Query Analyzer. Then, run these three lines of code. (I assume your SQL Server 2000 has default Pubs database).
Use Pubs
SET NOCOUNT ON
SELECT au_lname FROM authors
Then, change from SET NOCOUNT ON to SET NOCOUNT OFF and run them.
Use Pubs
SET NOCOUNT OFF
SELECT au_lname FROM authors
Spot the difference?
Okay, if you didn’t, the hint is at the left bottom tab. Click Messages tab. Got it? The difference is
Why we need to set it ON or OFF? Answer is performance. If set it ON, it has a better performance.
You can execute a stored procedure from another stored procedure. This means that you can create a common stored procedure so that any stored procedure which needs this common stored procedure can execute it.
Example, you have these three stored procedures. One is a common one. The other two are normal one.
Inside sp_update, you have
UPDATE mytable SET status ‘N’
Inside sp_delete, you have
@ID int
AS
DELETE FROM mytable WHERE ID = @ID
Inside sp_common, you have
@ID int,
@desc varchar(3000),
@submit_by varchar(50),
@submit_by varchar(50)AS
INSERT INTO mytable (id, desc, submitby, submitdt, status)
VALUES (@ID, @desc, @submit_by, @submit_dt, ‘N’)return 1
If sp_update and sp_delete need sp_common, just add one more line (if there is no return value).
Inside sp_update, add the line in bold
UPDATE mytable SET status ‘N’
EXEC sp_common
Note: You can use either EXEC or EXECUTE. They are the same. But EXEC() is a different thing.
If there is return value, then inside sp_update, add a declaration line and edit the existing execution line (in bold):
DECLARE @status int
UPDATE mytable SET status ‘N’
EXEC @status = sp_common
