I would like to shoot video of my band with the ability to edit the video and sync it to audio from within SPLAT.
   Does any one have a recommendation for video cameras that record in a format that's easy to import into Sonar?
   Also, does anyone know of video tutorials on how to work with video within Sonar? I'm too stressed and time constrained to read manuals 
  And one more thing. Can anyone recommend inexpensive video editing software. I'd like to work with 2 cameras and be able to switch between camera angles.
  Thanks
 

You can't work with video within Sonar.  It will playback video in sync so you can do your normal audio stuff, but that's it.
 
The usual way to do what you want is to import your finished audio to your video editor, then edit the video to match the audio.

I will make this recommendation - don't try to do this yourself if you are stressed and time constrained.  To do what you want will require a ton of effort on your part and could possibly end up not meeting your expectations when done.
 
As a rule of thumb, for every minute of video you want to produce, you should count on spending 1 hour of filming time.  Then you have the editing/post production time to consider as well.
 
Also, if you are trying to film and play in your band at the same time, you will probably end up doubling that 1 hour of filming per minute time.
 
i would recommend finding someone perhaps at a local university to work on this with you, that way you don't have to worry about learning new software, techniques and workflows.

I would recommend using Sony Movie Studio Platinum. It is cheap, very powerful and super easy to use. You can start new projects with musical tempo and meter and a lot of the shortcut keys are similar to the ones in SONAR.
 
I record, mix and master in SONAR, export that finished audio and import it into a SONY Movie Studio Platinum project where I sync the audio and video. I then edit all the different angles together with any visual effects or whatever. It works great. Sony and Cakewalk play very nice together. I have used this combo for many years.

Hey Jb1. Karyn is absolutely right. The video function in Sonar is just for playback, and it makes more sense to edit your audio first. You can get away with a whole lot more fudging of video shots and angles than audio takes! There are lots of consumer digital cameras that will give you great results. I have a couple of Canon handycams that have served me well. Get creative and throw in a couple of GoPro's as well! Most consumer models use very compressed formats, such as avchd. Most editing suites now support these formats, but due largely to the compression they are processor hungry and do not support smart rendering, so production is a bit slower than the pro formats. This doesn't stop you from getting great results of course. If you are recording live gigs, one of the specs you should look at when choosing a camera is its low light recording performance as conditions will often be less than ideal.  Check the price, the specs, then watch some amateur video demos on YouTube - they will give you a much better idea than any manufacturers promo.
 
Video editing is great fun - and a nice break from audio. If you are familiar with a DAW, video editing software is not a huge leap, and there are many very capable editors for under $100: Sony Movie Studio,  Corel Video Studio, Cyberlink power director etc. My goto editor for many years has been Sony Vegas, but it is a bit more expensive (and recently discontinued!).
 
If you get the chance, record in the same venue over a couple of gigs. Then your 2 cameras turn into 4. If you do record the gig on a single night, I suggest one camera be raised up on a tripod and the other be hand held and mobile. That way you always have a stable shoot to return to when editing, but have the variety and creativity of the mobile camera. 
 
Good luck and have fun:)

All good. I would just add that I would look for a camcorder with decent image stabilization. Even my old Canon VIXIA HF R500 has it, so that shouldn't be too big of a deal.

   Thank you guys for all of your input.
   We're renting a rehearsal room with a stage on Sunday as preparation for an upcoming show. I thought that it would be a good time to shoot some video to use to promote more gigs.
   We had a person lined up to shoot video that canceled. So now I'm the guitarist,engineer,music producer and video producer! 
   I'm thinking that I'll record the audio with a pair of mics into my laptop and then edit the video and line the audio up to it within Sonar. 

Shooting video to be edited later is a wise choice, just so you have it on hand and can finish it at your leisure. Quick suggestion for the video (now) that will help you when the time comes later on (to synch audio to video) is make some very blatant hand clapping easily seen by the video. Having those "easily found" transients in the audio/video will help you in the long run.

Karyn
You can't work with video within Sonar.  It will playback video in sync so you can do your normal audio stuff, but that's it.
 
The usual way to do what you want is to import your finished audio to your video editor, then edit the video to match the audio.

I'm just asking not being a smart butt... I don't know in Splat but in Sonar8, I imported video then added and edited audio to the finished video. Deleted original audio and added new audio... that can't be done in Splat? 
 
I did this a few years back the, dog voice was added in Sonar 8 as the video played. https://www.youtube.com/watch?v=bbsKKhTiJxQ

I do the exact same thing and it works like a champ... Have done paid videos for city promos, companies, products etc
There are lots of third-party effects that you can buy to that work great