Found a solution for what I'm looking for:

declare @DBRoleName varchar(40) = '[dbrolename]'

SELECT 'GRANT ' + dbprm.permission_name + ' ON ' + OBJECT_SCHEMA_NAME(major_id) + '.' + OBJECT_NAME(major_id) + ' TO '...

Don,

I think future maintainability is the main concern. We have several Crystal reports driving off of the same stored procedure and all of them require the same padded string....

Thank you for the responses! I'll give this a try. Looks like the solution might have been simpler than I had expected.

I've updated my original post to fix...

Thanks Aaron, I'll have to give that a try.

Incidentally, it appears our users who made this request have changed the requirement so that I will not need to group by...

Thanks for the responses!

Jacob, you're right, I missed something when pasting my sample data. I've corrected it in the original post.

Lynn, I may end up doing exactly that. ...

Here's the link: http://www.microsoft.com/en-us/download/details.aspx?id=15011

Thank you for the responses! I'll give these a try.

Hugo,

Thanks for the response! I marked it as the correct solution because I know I've seen SSIS used for this purpose, but I actually ended up dumping the data...

Thank you!

Thank you for the responses. I will give these a try!

Thanks Alan!

Yes. Only at the end.

Hi Sean. Thanks for responding.

After some more digging, I realize I no longer have a need for question #1. I've updated the initial post to reflect this.

I...

Lynn,

Thank you, this finally made sense to me. I keep forgetting that you used "not like" in the logic.

I appreciate your help!

But shouldn't the "%" characters on the outside of the "[^0-9]" mean that the first character of the last one before the hyphen could be anything?