Clips not mine. I just borrowed them.
http://www.stargatemanics.com/
Here's a scene from one of the best tearjerkers I've ever seen.
In this clip your listening to the song Tommy (the little boy) wrote because his stuck in hospital and wants to see his dad