I have a Canon G7 and a Canon 40D.
I've only had the dSLR for 2 months, and I think I'm finally getting the hang of it (well, some of it). Can take good shots with the G7 as I've had it for much longer and know where everything is. Really enjoy using the 40D though, it's great quality.
I usually take the 40D when I know there'll be a lot of photos taken, but throw the G7 in the bag if I just want a camera with me in case.
A few with the 40D:
And the G7: