Databases
StackOverflow2013
Postsdbo
POUnsupported Data Type Error
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnsupported Data Type Error
    text
    copied!<p>I have the following query with sub queries:</p> <pre><code>SELECT TOP (100) PERCENT Mtg2012.Employee_ID, Mtg2012.Mtg2012, Mtg2011.Mtg2011, Mgr2011.Mgr2011, Mgr2012.Mgr2012 FROM (SELECT TOP (100) PERCENT Employee_ID, Manager_Readiness_Rating AS Mgr2011 FROM dbo.v_sc17_TMS_Data_Career_Meeting_Rating AS v_sc17_TMS_Data_Career_Meeting_Rating_1 WHERE (Plan_Year = 2011) GROUP BY Employee_ID, Manager_Readiness_Rating) AS Mgr2011 FULL OUTER JOIN (SELECT TOP (100) PERCENT Employee_ID, Manager_Readiness_Rating AS Mgr2012 FROM dbo.v_sc17_TMS_Data_Career_Meeting_Rating AS v_sc17_TMS_Data_Career_Meeting_Rating_1 WHERE (Plan_Year = 2012) GROUP BY Employee_ID, Manager_Readiness_Rating) AS Mgr2012 ON Mgr2011.Employee_ID = Mgr2012.Employee_ID FULL OUTER JOIN (SELECT TOP (100) PERCENT Employee_ID, Meeting_Readiness_Rating AS Mtg2011 FROM dbo.v_sc17_TMS_Data_Career_Meeting_Rating AS v_sc17_TMS_Data_Career_Meeting_Rating_1 WHERE (Plan_Year = 2011) GROUP BY Employee_ID, Meeting_Readiness_Rating) AS Mtg2011 ON Mgr2011.Employee_ID = Mtg2011.Employee_ID FULL OUTER JOIN (SELECT TOP (100) PERCENT Employee_ID, Meeting_Readiness_Rating AS Mtg2012 FROM dbo.v_sc17_TMS_Data_Career_Meeting_Rating WHERE (Plan_Year = 2012) GROUP BY Employee_ID, Meeting_Readiness_Rating) AS Mtg2012 ON Mtg2011.Employee_ID = Mtg2012.Employee_ID </code></pre> <p>When I run this for the last 3 columns I get the UNSUPPORTED DATA TYPE ERROR but for the first one I get the records returned. It doesn't make sense because they are all being built off the same table. Could it be in the joins? I worked on this all night and could not resolve it.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload