You have a FOR XML query using ELEMENTS directive. You query ignores columns having NULL value and you want to include them. What should you do ?
Place the mouse cursor HERE for the answer
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro