All geek questions in one place

SQL VIEW Unsupported Data Type

I am trying to create an SQL view that joins two tables from different databases. SQL works fine in the query editor, but when I try to run it as a view, all columns from the MSP_EpmProject table say "Unsupported DataType".

SELECT TOP (200) dbo.Project.ProjectID, dbo.Project.ProjectGUID, dbo.Project.ProjectName, dbo.Project.DefaultBaselineID, FMM_ProjectServer_Reporting.dbo.MSP_EpmProject.ProjectName AS Expr1 FROM dbo.Project INNER JOIN FMM_ProjectServer_Reporting.dbo.MSP_EpmProject ON dbo.Project.ProjectGUID = FMM_ProjectServer_Reporting.dbo.MSP_EpmProject.ProjectUID
+6
source share
1 answer

Check this error report - http://connect.microsoft.com/SQLServer/feedback/details/464339/unsupported-data-type-reported-for-supported-data-types-in-nested-query

This seems to be a problem with SQL 2005, which they still haven't fixed.

The job seems to be to not work with your view in development mode, you will have to develop this view manually in the query analyzer.

+9
source

Source: https://habr.com/ru/post/944219/

More articles:


All Articles