Hi,
TDM has not been able to successfully model/reverse engineer/compare my sql server table valued functions.
For example the relevant DDL for one function is:
CREATE function [xxx].[ParseStringParamToDateRange] (@stringIn VARCHAR(1000))
returns @dateTable TABLE(
STRINGIN NVARCHAR(MAX)
, RangeTypeDesc varchar(100)
,DateVal DATE
)
AS
blah,blah,blah…
However, TDM reverse engineers the following:
CREATE function [xxx].[ParseStringParamToDateRange] (@stringIn VARCHAR(1000))
RETURNS
AS
That’s it! The reverse engineering loses the definition of the return table, so of course the sql in the model is invalid.
Am I doing something wrong in TDM? If I am not doing anything wrong, is there a workaround aside from manually copying and pasting the ddl into a model?
Thanks,
Ken