After SQL generates xml, add attributes to the root node

Declare @ ID varchar (20), @ name varchar (20), @ XML
Set @ ID = 'all'
Set @ name = 'select'
Set @ xml = (select note. gp_code 'id', note. gp_name 'name', item. company_code 'id', item. company_name 'name', items. dept_code 'id', items. dept_name 'name' from GP note join company item
On item. gp_code = Note. gp_code join (select * from Dept where dept_gp is not null) Items
On note. gp_code = items. dept_gp order by note. gp_code for XML auto, root ('root '))

Set @ XML. modify ('insert attribute ID {SQL: variable (''@ id'')} as last into (/root) [1] ') -- add the ID attribute to the root node
Set @ XML. modify ('insert attribute name {SQL: variable (''@ name'')} as last into (/root) [1] ') -- add the name attribute to the root node
Select @ XML