Please help me! Nose piercing question.?

It will be sore - I've had mine done twice now - but it shouldn't be so much of a problem that it ruins anything that you'll be doing. It's really not that painful as long as you leave it alone besides cleaning it. It doesn't drain or swell the way other piercings do.