I have two probably easy questions :)
The first is - what is wrong with this syntax:
This is a stylesheet for excel - I want to account for names that could go beyond the max length of 31.
This is the message I get:
XML ERROR in Workbook Setting
REASON: Bad Value
The second question has to do with a documentation sheet. The sql code must be documented in the workbook. The code has indents and spaces like:
SET Loantotal = a.loans
SELECT Year(dateContract) Year, datepart(q,datecontract) MQ,
WHERE dateofdata = 'Sep 30 2004 12:00AM' ....
I can retrieve this code from the data and get it in to an xml file (with spaces) but when I open it in excel i get:
Update tblTriangle_Dollar SET Loantotal = a.loans
FROM (SELECT Year(dateContract) Year, datepart(q,datecontract) MQ,sum(amtloan) Loans FROM smolinski.tblMasterMonthlyData20040930 WHERE dateofdata = 'Sep 30 2004 12:00AM'
Without word-wrap it is one long string. I would like to keep the indents.
Currently the code is one cell (e.g. <code>my code<code/>) - In other word each line is not separate out. It is formatted the way i want it in text form - it just doesn't translate to excel.