SQL Server 2008R2 - 从多个表中插入

I am having an issue (well two issues actually) with my stored procedure, and I could be making a rookie error here but I've attempted to fix it and failed miserably. Enter the gurus of stack overflow to save me :DI am having an issue (well two issues actually)