Hi all,
I am having problems with the concat function.
This is the query:
SELECT
CONCAT('<row><ReqId>', t1.ReqId, '</ReqId>',
'<ReqName>', t1.ReqName, '</ReqName>',
'<ReqVersionId>', ReqVersionId, '</ReqVersionId>',
'<Type>', t1.Type, '</Type>',
'<Author>', Author, '</Author>',
'<Detail>', Detail, '</Detail>',
'<Status>', Status, '</Status>',
'<DateCreated>', DateCreated, '</DateCreated>',
'<LastUpdated>', t1.LastUpdated, '</LastUpdated>',
'<AreaCovered>', t1.AreaCovered, '</AreaCovered>',
'<Priority>', t1.Priority, '</Priority>',
'<Level>',h.Level, '</Level>',
'<IsLeaf>', h.IsLeaf, '</IsLeaf></row>')
FROM requirement ...
and here the result:
CONCAT('<row><ReqId>', t1.ReqId, '</ReqId>',
'<ReqName>', t1.ReqName, '</ReqName>',
'<ReqVersionId>', ReqVersionId, '</ReqVersionId>',
'<Type>', t1.Type, '</Type>',
'<Author>', Author, '</Author>',
'<Detail>', Detail, '</Detail>',
'<Status>', Stat
NULL
NULL
...
It seems that there is a maximum lenght fot the arguments list of concat.
Is it true? How I can override this limitation?
Thanks in advance for any help you will provide.
Best regards