But yeah, once you do this, it usually ceates a thousand tempo changes (120.3, 122,119etc)......So i guess i could just make note of the changes and undo the tempo map? 
 

And yeah, i dont know how to draw a straight line in tempo veiw window...........Im in sonar not photoshop

And like, i went into project set new tempo, and it only changed it for like one bar, and then goes back to the tempo it was afterwards
 

Here's the official docs. Make sure you check the links at the bottom, as well.
 
https://www.cakewalk.com/Documentation?product=SONAR%20X3&language=3&help=AudioSnap.07.html
 
Here's a related thread.
http://forum.cakewalk.com/How-to-draw-straight-line-in-tempo-map-m3399045.aspx

here goes my advise in a nut shell...
 
Break the parts of the song up in to sections.
Hook, Verse, Bridge, Chorus and so on..
Then listen to each section and use the tap tempo button in project/insert tempo.
once you have determined all the different tempo changes write them all down.
 
Start a new project and use the insert new tempo feature. (this of course includes mapping out the beats of your song.)
trying to match a tempo to a pre recorded riff can cause a lot of issues especially with tempo drifting.
everything and I mean everything, every little riff can be mapped and often should be to keep consistent musical time frame.
 

Yeah cool chuck, thanx mate!!!

And yeah chuck, just tried both methods, dragging audio to timeline gave me an average tempo of 132bpm, which when i tried to play over it....nope......i began bashing head against the wall........then i tried tap tempo method, as you suggested, came u with 91bpm,.....and yes it feels right to play over.......So thanx for your priceless advidce once again

paul jenkins
And yeah chuck, just tried both methods, dragging audio to timeline gave me an average tempo of 132bpm, which when i tried to play over it....nope......i began bashing head against the wall........then i tried tap tempo method, as you suggested, came u with 91bpm,.....and yes it feels right to play over.......So thanx for your priceless advidce once again

No probs man.
I do a lot of Tempo matching projects and I've tried a lot of different methods within sonar.
Matching to Tape is the hardest because of capstan motor variations. but once a structure can be established then the tempos can be rebuilt with precision, discarding the original scratch track/tracks.
 
 

I think if you are having the project follow the detected tempo, that any time those detected tempos change, it will overwrite anything you had set up prior to that, so if you are going to use your own tempos, make sure other tempo changes aren't then coming along after and making additional tempo changes that you no longer want.
 
I usually do my own tempos - though if trying to match project to detected tempo it could get pretty weird (like what you seem to be going through).  But the way I look at it, if I am matching up to an imported track's tempo, then I don't know why I would then want to insert additional tempo changes of my own within the other tempos.
 
Bob Bone