Fred,

Calgary is has been my home for the better part of 30 years. The only casino with a hotel I believe is the Deerfoot Casino, but the location is in the deep south of Calgary. If you want to be closer to the action and the spectacle that is the Stampede I suggest you stay closer to the downtown core.

Yeeeee haaaawwww!