Convert from SQL to XML wuthout having multiple tags

Im pretty new to XML usage, im trying to achieve something like what was asked on this question here
Converting rows to XML format in SQL Server
But instead of having <tag1>value<tag1> I need the output to be <tag1=value>, so using the original example the output would be something like
<period_sid period_sid=1802 PROJECTION_SALES=1595642.121 PROJECTION_UNITS=18834.75725 ACCOUNT_GROWTH=0 PRODUCT_GROWTH=0>