Sunday, 1 December 2013

It's Erjie's Big Day!!!

Scribbled by TeddieDebbie at 23:58 0 scream(s)
OHMAIGOD I CANNOT BELIEVE ERJIE IS ENGAGED NOW!!!

Please bear with me it's kinda wordy at first.

It's actually on Thursday when I was working. Jackie FB messaged me asking me if erjie is around me. I thought this fella got problem ah coz it's a weekday and weekday is working day LOL somemore I was busy with projects but I was curious with what he wanna say till dowan erjie is around so I asked him to spill.

First thing he said is to ask me to calm down lololol izzit a known fact that I'll be surprised ah XD Then he told me he's gonna propose to erjie!!! *Start hyperventilating* ON THIS SUNDAY (which is today la)!!!!! I was like OMFG erjie's gonna get married soon LOL although it's just a proposal BUT after proposal then it's gonna be ROM then it's the wedding day ady!!! OK I totally lost focus and I was like OMFG it's erjie's proposal finally CAN YOU IMAGINE??? ONE OF US IS GETTING PROPOSED TO!!! Ok I don't know why I'm so excited la ahaha maybe she's been the closest sister to me since young before we separated to college/university and I'm really happy to see the partner she chose is really meant for her. =')

Anyway he said he'll drop by to ask for papa and mami's blessings on Friday night la and he hoped I can keep it secret and down low so erjie can be surprised coz she thought he'll only be back tomorrow (2nd Dec). *Hyperventilates more* I cannot imagine how they'll react!

So on Thursday night, I told papa and mami and kitkit happened to be there. Well their reaction is kinda within my expectation la. Papa was taking it as a joke (not quite able to accept it I guess lol) and keep saying wanna tell erjie ahaha. When kitkit heard it then he just lied on the bed like he got a very big shock LOLOLOL then he also threatened say wanna tell erjie WTF why everyone likes to play this kind of joke. Then mami just kept quiet I asked her did she hear what I said she didn't response to me wtf. After the announcement then we resume what we were doing wtf like it's just 轻舟泛过湖,泛起阵阵涟漪 and then the 涟漪 just disappeared wtf.

Jackie came to our place on Saturday afternoon coz his flight delayed and papa needa work half day on Saturday. The traffic was bad ah when he reached it was already 3pm+ and everyone was napping LOL. I woke everyone up then asked them to go into the study room and when Jackie entered the room, they start discussing ady and MY PHONE WAS IN THE ROOM WTF OTHERWISE I COULD'VE RECORDED PAPA AND MAMI'S REACTION FOR DOCUMENTATION PURPOSE!!!!!

Here's the conversation... Roughly to my memory la.
Jackie: Aunty uncle, I wanna let you know tomorrow I'm gonna propose to Ivy ady at Cineplex, e@Curve...

(Papa kept quiet)

Mami: Okay...

Jackie: ... and I hope I can get your blessings.

(Papa still kept quiet)

Mami: ... You must treat her well you know...

Jackie: Ok.

Mami: ... If you bully her I will find you 算账 ah....

(LOL)

Jackie: Ok ok can.

(Me: Can say cannot meh!!! LOL)

Then Jackie told me the TO-DOs and left wtf.

Anyway I managed to ask him la what it's gonna be. He said it'll be in Cathay Cineplex, e@Curve, papa and mami will be sitting inside the cinema and I'll be standing outside with him. Then I was like, eh why so familiar one, isn't it XiaXue style?!?! I asked him did he watch the video la but he said everyone is doing it (Pfft so mainstream) Then he said he's gonna appear as Iron Man OMFG

That's like, my favorite Marvel hero leh! He's the only one that dare to challenge the enemies to find him at his own house (sibeh badass can!) and he didn't need any superpower - just his talent in building his suits - to fight!

Jackie also said he's been planning it for a year ady OMFG *thunderstruck*

Yesterday erjie somemore told me about things I have to adhere if I wanna workout and slim down! (YES YOU PEOPLE, I FINALLY SUCCUMB AND WILL WORKOUT! YOU HAPPY?! Please don't make a big deal out of it tqvm!) We talked as if it's not her big day tomorrow LOL. She asked me somemore what am I doing on Sunday, I had to say "grocery shopping" lololol.

* * * * * * * * * * * * * * * * * * * *

So today is the day!!! Everyone woke up on time but then papa and mami kept shouting for kitkit and sanjie to get ready I had to shout back at them that they don't have to follow coz Jackie said it's gonna be in the Platinum Hall (WTF!!! I haven't been into any premiere halls in my whole life!!!) and it can't be too many people at a time. Then at about 10.15am we were about to leave ady then mami still say wanna have breakfast wtf BUT Kitkit said he needa see doctor coz he's bloated after eating mami's curry LOL wtf so no choice gotta take him to the doctor first. The clinic was a bit crowded la wtf gotta wait awhile so we went to eat first (At this point of time I'm already #facepalm coz I foresee we're gonna be late).

Anyway! Managed to send them home and started our journey to PJ ady ^^ and here I think I can start posting pictures ady ha.
Die die also put one first coz I appear very little later

Supposed can reach on time wan BUT I SCREW BIG TIME WTF!!!!! *Cannot forgive self* Papa asked me where izzit I said "The Curve" but padahal e@Curve DOES EXIST WTF I THOUGHT BOTH ARE THE SAME! WHY THE HELL THERE ARE SO BLOODY MANY CURVES AROUND THE AREA!!!!! Then papa U-turned and traffic damn bad walaowey where are all the traffic comes from!!! It's bloody Sunday why these people just don't sleep at home larh!!!!!

We're supposed to reach at 11.15 but we reached at 12 wtf T___T JACKIE WO DUI BU QI NI!!! (Although afterwards then only I realize he will only propose at the end of the movie wtf -_-) So as I said, I waited outside!

Everyone
Jackie's cute little niece can't stop running around and making noises but love taking photos lol

REAL ROSES! First time seeing so many in my life wtf
Very de 有份量!
Totally imitating this one LOL Got look alike anot???

Then suddenly they said "GET READY GET READY!" We hide at the entrance and after Jackie finished his words we just went into the hall!
Say vows
Show ring
"OMG YES!"
Kiss
"NO! I didn't wear my shoes!!!"

LOL that's what I will do when I was in cinema XD

"OMG MAMI YOU'RE HERE"
"OMG PAPA YOU'RE ALSO HERE"
"OMG I'M SO SURPRISE!!!"
Photo with the parents
Photo with the family
Got interviewed on how she felt =D
Mami's girl is engaged~
Erjie was like, am I dreaming??? LOL
You know what this bugger said? "Lucky I slim liao!" WTF!
Pretty! But mami's hand kacau aiks.
Take 2
I'm engaged!
See how happy papa and mami smiled =D

That concludes the whole event la.

So at night, we went to their house for the party and they've got -
LOK LOK VAN!!!

While I was happily ordering away, aunty said "少吃一点炸的东西 ha" wtf -_-


Ps: I'll leave the details of how she's been 'cheated' to the cinema for her blog! =D

Pps: Everyone started saying me and my sis look alike again! One of her friends asked am I her younger sis somemore! ^^

Ppps: Very sian is that people start comparing after the event. "Slim down la" "Keep fit la" wtf. Then parents will say "next time your wedding must get a row of BMW queue in front of your house and fetch you wan ah" "next time your wedding must be more grand than this ah" "next time your ... " "next time your ... " AAARRRGGGHHH wtf! Hate this part.
Categories
Share/Like to turn a rhinoceros into a unicorn!

Saturday, 30 November 2013

Update of My Broken Chin

Scribbled by TeddieDebbie at 23:54 0 scream(s)
Warning: You'll be seeing my stitches so be mentally prepared.

Story of why/how it happened can be read here.

I was napping when suddenly a friend called then I answered out of reflex wtf. I totally forgot to put my phone on silent coz, no one actually called or texted me during normal days, let alone nights.

It's too late for a nap anyway wtf. I overslept >< Argh thanks for waking me otherwise I'd just sleep all the way till morning.

So I was asked about my chin. Then I realize, I haven't update my chin condition! So here it is.

On 15th, I went back to the clinic and get my dressings changed after my work. Then the nurse had a small talk with me.

Nurse: Why you come at this time?

Me: Coz I've got work.

Nurse: You didn't take MC? How come you didn't take MC?

Me: I got! The doctor gave me 2 days only. I was hurt on Wednesday, so the MC was Wednesday, and yesterday.

Nurse: Oh! You can extend your MC you know.

Me: IZZIT?!

Nurse: Yeah, you can MC for 7 days you know, you've got stitches! Maximum 7 days.

Me: I didn't know!

Nurse: Yeah you can come back and get your MC extended actually. (Trying to ask why I didn't extend my MC again) Oh ya you didn't know.

Walaowey! Yuan lai got stitches can take MC for 7 days ga! Didn't know that!!!

The nurse asked me if I wanna extend my MC but ugh nevermind lah I don't work on weekends also. Somemore MC for a stitched chin like making it a big deal wtf. But very sian one ah! Changed my dressing only also charge me RM15! >:(

Nah this is before I remove the stitches!

I had to ownself buy the waterproof dressings to get changed every 2 days. Hello doctor, if you gonna charge me that much, at least gimme better dressings can?
At least something like this la! One pack is like RM12 only from Watson. Better than the gauze and paper tape wtf coz I have to ownself make a plastic cover somemore to prevent my wound from getting wet everytime I bath.

That night gotta celebrate Kuan's birthday somemore.
Me no pretty liao =(

The nurse said I can remove the stitches after 7 days so I went to the clinic on 23rd thinking it's ok for going 1 day later (coz 7 days after 15th is 22nd) but the doctor said I should go on 20th wtf so they start counting on the day I got my stitches ah!

I've gotta wait again coz the doctor went out for breakfast wtf. I thought 24-hour clinic should have other doctors!

Lemme tell you how I felt when the stitches were being removed.

VERY PAIN CAN! The doctor just pull and cut the strings wtf OUCH!!! T___T Then kena pay RM30 for that.

LESSON: DO NOT TRIP.

So my advice is, if you can, study medical. If I do my studies properly, I could've been a doctor right now and earning so much already. If I hate you I can make things rough for you too, ie being rough when removing stitches for you! T___T

And then - JENG JENG JENG... I removed the bandaid on Monday and I FINALLY CAN WASH MY FACE!!!

For the past weeks I can only use wet tissues to clean wtf coz it cannot touch water.
See got scar liao ='(

Anyway the pharmacist in Watson KLCC told me I don't have to put on anything yet la coz I'm still young ma so just wait the scar to vanish can ady.

Ps: Another lesson - REMEMBER to remember your panel clinic coz if you go to non-panel clinics, you might not be able to claim it - Like me! UGH FML!!!

Pps: No one in my team realized I've removed my dressings wtf.
Share/Like to turn a rhinoceros into a unicorn!

Friday, 22 November 2013

MIVVA Beauty Box: November Edition - BFF Sleepover Kit

Scribbled by TeddieDebbie at 13:16 0 scream(s)
When I first received the box, I was like "Wooooots~" coz the theme is BFF Sleepover Kit! Kinda eager to know what's gonna be inside it =D
Pinky and Raccoon presents - November BFF Sleepover Kit!
Items in the box
Look! Special item is the loofah.
One of the toiletries to bring at a sleepover!

Antipodes Joyful Hand & Body Cream
RM149 for 120ml
Together with RM20 voucher~ Though I didn't use much, I liked the smell =D Very fruity! The fragrance is from wild blackcurrant. Other elements includes avocado oil, wild blackcurrant berry and hibiscus flower.

Neula 5 in 1 oil control face lotion
RM22.90 for 30ml
Full size!
I see we're given either one from Neula 2 in 1 Tea Tree Oil Control Cleanser, Neula 5 in 1 Oil Control Face Lotion, and Neula 8 in 1 Tea Tree BB Cream SPF30 PA+++. I forgot what option did I put in my beauty profile ady =( But my face is rather dry than oily leh. I kinda hope I got the BB cream. But oh well, even if I got the BB cream, I wouldn't be able to try out by this month because of my injured chin. Might as well keep it sealed and give away as Christmas present.

Facial essence collagen mask
RM198.80 for 15g
L♥ve max! Very moisturizing. If constantly apply then probably can rejuvenate the skin.

Stage Nail Color, RM35
Full size!
So sad la I got Pearl White. When I applied, it looks just like I'm sick and pale =( Good texture though! But my base coat ruined them all argh.

Onl Dermost Moistay Cream
RM144.90 for 60ml
Onl Dermost Moistay Fresh Gel Cream
RM144.90 for 60ml
Too bad! Before I get to try out these 2 creams, I knocked my chin wtf! Can't touch water so I try to keep my face naked. As in no makeup la. But you know KL air lo! Very polluted. Before I wash my face I also don't dare to apply anything in case they got wasted because the pollutants on my face blocked them.

If you're interested to get one, subscribe here! It's gonna be Christmas soon so maybe just try for 1 month and treat it as a Christmas present!
More information on MIVVA site and MIVVA Facebook.
Categories ,
Share/Like to turn a rhinoceros into a unicorn!

Thursday, 21 November 2013

SSRS 2012: Limit Number of Records Per Page

Scribbled by TeddieDebbie at 11:56 0 scream(s)
Note: Cuppycakes that came to this entry because it's really urgent to know how, kindly Ctrl+F "Begin:" to get to the point.

* * * * * * * * * * * * * * * * * * * *

Yo! First time doing tutorial here. As erjie and Serena has mentioned, I'm gonna do an experiment.

Aim: To find out which post categories are more popular.
Hypothesis: Tutorial posts are more popular compared to other lifestyle posts.
How to determine: Page views.
Duration: 2 weeks

* * * * * * * * * * * * * * * * * * * *

Begin:

Assuming you have a report created and you wanted to limit the number of records per page in SSRS. I suppose there's no default way to manage it but to create a workaround. Here's how.

Step 1: Right-click the Tablix handle "Details" at the Row Groups section, select "Add Group" and then "Parent Group..."

Step 2: When new windows appeared, click on the "fx" button at the right

Step 3: In the empty space, insert the formula/set the expression.
There are a few formulas that can be used:
1. =Ceiling((RowNumber(Nothing)/x))
2. =Floor((RowNumber(Nothing)/x))
3. =Int((RowNumber(Nothing)-1/x))
Where x = the number of records to display per report page.
(Source: MSDN Blogger)

There are difference between Ceiling and Floor when comes to double/float type:
a) SELECT CEILING(12.345), CEILING(-12.345) resulting in output of 13, -12;
b) SELECT FLOOR(12.345), FLOOR(-12.345) resulting in output of 12, -13.
(Source: TechNet)

But here you have nothing to worry about, the results will be the same because the parameter used is RowNumber. RowNumber is int, not double/float.

Step 4: When above steps done, the windows will become like this. Do not change anything, just click "OK".

The report should have following changes:
Step 5: Check for the new Group1 as Parent Group for "(Details)"
New column appeared beside the existing report column.

Step 6: Right click on the column of newly formed Group - Group1, and select "Delete Columns"

Step 7: Be extra careful not to select "Delete columns and associated groups". If you carelessly *ahem* deleted it, you've gotta start from Step 1 again.

Step 8: Back to the Row Groups section, right click "(Group1)", and select "Group Properties..."

Step 9: Select tab "Page Breaks", ONLY select option "Between each instance of a group"
Step 10: Select tab "Sorting", click on (not into!) the only column and delete it.

Voila! Now you can view your report with limited records per page!

Additional: As this is just the workaround, the report file exported in Excel format will show the records as per limited/set too - where pages will be displayed as sheets.

* * * * * * * * * * * * * * * * * * * *

Let the fun begin!


Update 2014-07-18:
Turned out this method is able to solve the Excel records limitation issue! Check out this page to get the idea.

Please note that the SSRS report will display the records in the exact same sequence as displayed in Excel sheets, so it is recommended to group them in the SQL statement beforehand.
Categories ,
Share/Like to turn a rhinoceros into a unicorn!

Wednesday, 13 November 2013

I Broke My Chin

Scribbled by TeddieDebbie at 18:18 0 scream(s)
Way to start my day yo!

You know, life has its own way to play its cards. Just yesterday, a friend talked about the taboo her mom mentioned. For example, a broken/cracked glass can bring bad omen, and it's not a joke when it comes to coffin and stuffs.

I violated both the taboos.

I own a phone that has cracked screen, and I was in a coffin.
Living person is said to not stay inside a coffin

This morning, the bad omen has reached its limit. I woke up on the wrong side of the bed, left foot stepped on something that's attached to the right, my right foot didn't seem to go over that something, and then I tripped - BAM! Knocked my chin on the bedside.

At first I felt sore like someone punched me on my chin and just when I was about to let out a curse - I felt something warm flow down towards my neck.

Blood.

And here's the funny thing! I'm not sure izzit because I was shocked, I got stomachache suddenly and I had to go to the bathroom and take a dump wtf!

Pain at the top and the bottom wtf.

After I'm done, I went back to the room and wanted to change my clothes when suddenly - I felt like wanna take picture.
Left: wound
Right: blood stained cotton

OMG I'm the person who will ask people to take picture and post on SNS when me or someone else has a misfortune!

So I went to clinics. They opened before the doctor is in WTF! How can they be ignorant on patients' well-being?! They came, they registered, and then? Wait forever till the doctor come?! I waited in the 24-hour polyclinic KL (seriously, 24-hour and still no doctor!) for quite awhile then only I heard the doctor came -_-

Doctor gave me tetanus shot first and then only gave me local anesthesia. It was my first time getting stitches! Damn scared leh. Now I know why some people die die also dowan go into surgery room!!!

Long story short.
I've got 2 stitches in there!
The doctor gave me 2 days MC! Muahaha!

Friend: You pokai? How ady?

Me: Chin kena saja lor. Very de suay.

Friend: How you land on chin?

Me: Because my chin too long XD Oh! You don't know I'm a monster at home!

Friend: -_- You reminded me of 1 litre of tears.

Me: Oh wtf. I'm very normal!

Friend: Land on chin where got normal! You never hear them explain?! Human reflex will make your hand to support first.

I'm not gonna demo.

Ahem. So after the suay incident, it's about 10.30am already. I went to Lowyat Plaza and get my phone fix once and for all. Surprisingly, it took only 1 hour! I thought it's gonna be like weeks then only can get the phone back, which is why I dragged it (die die also dowan admit the laziness to go Lowyat Plaza) coz everytime I wanna fix it, I sorta foresee I need to take picture ^^"

FYI, cracked screen costs RM650. Sibeh expensive. Silver rim costs RM120! Siao eh.

My phone and I got patched up together on this day neh :p Also it indicates that I overspend again T.T
Share/Like to turn a rhinoceros into a unicorn!
 

Teddie • Debbie Template by Ipietoon Blogger Template | Gadget Review