SCOPE_IDENTITY must be executed as part of the same batch, otherwise it won't see the ID -- that's why I'm appending it to the same command as opposed to running separately