之前看到
![[info]](http://l-stat.livejournal.com/img/userinfo.gif){kind=small}
fiona_zhon发的新闻，虽然很多年没有关注过娱乐八卦，看到那个还是心里很难过。居然心情不好几天，虽昨晚收到短信，在Facebook看到新的消息，链接不能用就代替用这个。我一下子心情很好。
以前听他们说为什么非要用一张纸绑住对方，现在看来他们是太天真了，结婚证书不是一张
这个好像是我很久很久以来写的最长的中文，没想到还可以用那么多“书面语言”，好像自
说到identity，it's been my own struggle for years。今天看到一个人的相同问题，真的很感谢最后那个Anonymous留言的人。道理我都知道，可是还是struggle。
- Location:Sandy Bay office
- Mood:
good
It feels really good to see those familiar names again.
欢迎回来
- Location:Sandy Bay office
- Mood: good
Can't believe that I've actually spent 18 and half years being a student! The best years of my life, gone, just like that.
I hope it's all worth it.
We'll see.
- Location:Sandy Bay
- Mood:
excited
And today I saw this news. No wonder they claim that they catch whales "for scientific purposes". It cracked me up, I mean, cows and whales? Why don't they think of shark and whales, or cows and sheep, but cows and whales?
- Mood:
indescribable
At Wet 'n' Wild, upon crashing into the water from a large water-slide, my bikini came off (not "off", just out of position, but bad enough). And I didn't know.
I walked out of the water and turned around to sit down watching other people coming down the slide. About a minute later, I stood up and started leaving, the life guard then saw me and gestured to me... I wonder how many people saw.
You bet after that I always checked before I came out of the water. And it did happen once again. Lucky I checked.
- Mood:
embarrassed
2 and half years ago, I signed up with a gym for 6 months, but went 2 or 3 times, wasted all that $.
Today, I went to a gym to have a fresh start. Within 7 minutes' "warm-up", I fainted, literally. What a loser.
I didn't actually collapse, but almost. I stopped as soon as I felt it coming and told the coach, and we went and sat down.
But I'm going back tomorrow to do it again. This time i won't go without breakfast.
- Mood: embarrassed
I said that homepage came and went, then came the blog, now the networking sites (not only social but business, too), however, I would still go back to the homepage way. And I did pick a hosting service, just haven't paid yet (and couldn't think of a domain name). Looks like I may not have enough time to build my site this summer anyway. I wonder why my 3-month holidays are half gone already?
Back to my new camcorder. I've been loving it. Made 2 dvds to give people as Xmas presents already. Doing a slightly bigger "project" for my parents at the moment. Here, have a look at the size:
- Location:Sandy Bay
- Mood: relaxed
I heard this one is only about the size of a coke can. :p
But what's the use of getting a HD camcorder when I don't have a HDTV (in fact I don't have any TV) yet?
- Mood: excited
This journal is now FRIENDS-ONLY.
You will have to be on my friends list and logged in to read my previous entries.
I'm not sure what I'll do with my future posts. Just want to lock previous ones until I figure out what I'm gonna use this journal for.
- Mood:
contemplative
I cannot believe T-SQL doesn't have a median() function.
There are many people posting their own online, but many of them are not correct or at least not simple enough.
| declare @varMedian table( Median int, ID int identity) insert into @varMedian (Median) select [Age] from [@varPatientList] order by [Age] ASC declare @Count as int,@Median as int set @Count = (select count(*) from @varMedian) set @Median = (@Count/2 +1) --to get the median number-------------------- (Select Median from @varMedian where ID = @Median) |
But since it relies on the identifier, if, in this example, you want to get the median age of male, and female, and both, you'll need to create 3 temporary tables, which could be annoying.
And I heard the new version would allow user to write their own functions, so this won't be an issue then.
- Location:office, Hobart
