I've done this a number of itmes, if you could post the sp that you tried to create I might be able to help.