It might just be me, but I;m afraid I don't understand what you're trying to achieve here.

My confusion arises from "those column values should added as a xml...

There's an article on TechNet about this on for SQL 2008-2014, I would hazard a guess that the same would apply for 2016 as well: http://social.technet.microsoft.com/wiki/contents/articles/24364.sql-server-troubleshooting-could-not-find-database-engine-startup-handle-error-during-installation.aspx

If that doesn't...

Both char and varchar are non unicode strings. You don't want to do a conversion to DT_WSTR if your source and destination fields are either of these types. Take the...

You need to use a date table. Have a look at Bones of SQL - The Calendar Table[/url]

So, for example, you can then do the following:
CREATE TABLE...

The code I gave you would...

What do you mean by insert blank rows. Do you mean that you want rows for Months 1-8 and 10 displayed on your top account?

If you want Powershell/CMD to go straight to sqlcmd, you could make it a shortcut with the command passed through

For example:
C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -Command "sqlcmd -S MySQLServer -d TestDB...

A nice to have, but when using the IFCode tags with SQL, starting a line with -- doesn't display the text in the comments colour. Wrapped in /* */ works...

This is a bit of guess work based on data you provided in prior posts, and the above but something like this should work:
--WITH XMLNAMESPACES(DEFAULT 'MgmsSchema/Business_Information_Detail_Entry') --Not sure if...

Good to hear you got it working.

If you're going to be changing the way you present your data in the presentation layer, always return the data in it's...

You're SQL language won't make any difference to how format works, no. You define the format using characters, for example dd = two character day, MMM = three character month....