Daniel,
Thanks for your reply. But the link didn’t help me.
After I add generated items using a stored procedure without parameter to retrieve data, according to article I read at http://www.codeproject.com/KB/biztalk/SP_XML_CLAUSE_BT.aspx , I need to change the schema location so that it will use the shema that is automatically generated by executing the stored procedure in SQL Server Management Studio.
My issue is: I cannot change the schema location. It seems to be read only.
The stored procedure is very simple like this:
ALTER
procedure [CMCustomer].
[p_biztalk_salesExpiraton_updateOR_RYGandADP]
as
SELECT
ConsistentNames.ConsistentName, custsummary.OR_RYG, w_ConsnameDaysToPay.
psixmonthavg
FROM
ConsistentNames RIGHT OUTER
JOIN
custsummary
ON ConsistentNames.ConsistentName = custsummary.ConsistentName RIGHT OUTER
JOIN
w_ConsnameDaysToPay
ON ConsistentNames.ConsistentName = w_ConsnameDaysToPay.
consistentname
FOR XML
AUTO