Loading a view throws exception about sqlsharpener HOT 3 OPEN

I spent some time looking at this problem. When I used DacExplorer, I can see the column is defined as a ComputedColumn and type type references the origin table's column. My guess is the correct way to determine the view's column type is to look up the data type of the source table's column.

from sqlsharpener.

Not sure if we can loop through the source columns used in the expression, but if we can we might be able to derive a type that will work. For example, if all columns are int then use int, else if all are numeric, but at least one is decimal or float then use float, else if any are a string then use string.

I think a work-around might be to wrap your expression in the view with CAST as in Cast((col1 + col2) as int) AS ColName.

from sqlsharpener.

I received a similar error in any table script where a column is a calculated column. I ended up having to modify my T4 to simple ignore any table that had a calculated column, as I tried multiple solutions to try to get it to work with the calculated column but had no luck.

from sqlsharpener.