I have sample data 

```
DECLARE @Table1 TABLE (users int, ts int, name varchar(10), [1] int);

INSERT INTO @Table1 (users, ts, name, [1])
VALUES (1, 1, 'Raj', 0),
       (1, 3, 'maj', 2534),
       (1, 10, 'yes', 1458);

```

If I'm trying to add 

```
select
    'test' as 'job/branch/FBEN/opcode',
    users AS 'job/branch/FBEN/opcode',
    name as 'job/branch/FBEN/opcode',
    [1] AS 'job/branch/FBEN/opcode/1'   
from 
    @Table1
where 
    ts = 3
for xml path('xmlexecute'), elements;

```

I get an error:

> 
> Msg 6850, Level 16, State 1, Line 14  
> 
>  Column name 'job/branch/FBEN/opcode/1' contains an invalid XML identifier as required by FOR XML; '1'(0x0031) is the first character at fault.
> 
> 
> 

how can I get the result like this : 

```
 <xmlexecute>
      <job>
        <branch>
          <FBEN>
            <opcode>1</opcode>
            <opcode>3</opcode>
            <opcode>maj</opcode>
             <1> 2534   </1>
          </FBEN>
        </branch>
      </job>
    </xmlexecute>

```