I take it you are referring to the Hockey Night in Canada musical
theme that was played at the introduction/closure of the televised
games from the mid-60's through to the mid 2000's. This theme
is not a song since there are no lyrics. Unfortunately the British
composer of this theme refused to renegotiate the use of her
composition with the CBC television network and so it is no longer
heard. The musical score may be available in some music stores.