Something like this should do it:

SELECT CONCAT('USE ', u.DBName, '; ALTER ROLE [db_owner] DROP MEMBER [', u.Username, '];')
FROM @USER_table u
WHERE u.Username = 'Frodo'
ORDER BY u.DBName;

I'm not sure I am convinced. How do you manage version control for the database objects which are being generated? Doing this means that you lose many of the consistency...

Or do it the way I...

Please read this article for details showing how to post sample data.

If you are hoping for a coded solution, please provide some sample data in the form of consumable CREATE TABLE and INSERT statements, along with desired results based on that...

WHERE ROOM_NUMBER <500 or ROOM_NUMBER >= 600

perhaps? If it's an INT. If it's a string, you could do something like this:

WHERE ROOM_NUMBER NOT LIKE '5%'

Yes, conn managers should be checked in with dev / local connections and that is how they should remain, as far as source control is concerned.

After deploying packages to QA...

This line looks weird. What is it supposed to do? Strings and INTs mixed in the same list?

where o.status dbo.in ('D',1,2,3,4,5)

Righto. Have you considered creating a post like this?

"I am trying to import some XML files into SQL Server tables, but I am not sure how best to...

Yes it can... so can C#, Visual Basic,...

Yes it can... so can C#, Visual Basic,...

What sort of feedback are you expecting? If someone here says 'Yep, looks good', does that mean you will push the code to Production?

And when there's a problem, you'll be...

Jeff, that's nice work. Thanks for reminding me of ROLLUP and GROUPING too.

There is no syntax error in that code. I just copy/pasted and ran it to be sure that the rendering had not affected anything.

Which version of SQL Server are you...

Please post a question only once. Answers here please.