<div>
This is driving me crazy!!! 
 
When i comment these fields out it is working perfectly fine 
 
-- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,SubTaskEle.LAST_UPDATE_DATE AS [PSA SubTask Status Date] 
-- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,isnull (SubTaskEle.DESCRIPTION, '') AS [PSA SubTask Overview] 
-- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,Isnull (SubTaskStatus.PROJECT_STATUS_NAME, '') AS [PSA SubTask Status] 
-- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,isnull (SubTaskStatusChanger.FULL_NAME, '') AS [PSA SubTask Status Changed From] 
-- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,isnull (PcompletSub.progress_comment, '') as [PSA SubTask Progress Comment] 
 
PLEASE HELP ME ! XD 

<pre><code class="code-100 nolinks" id="code-262368">SELECT
-- Project 
PA.PA_PROJECTS_ALL.NAME AS [PSA Project Name]
,PA.PA_PROJECTS_ALL.SEGMENT1 AS [PSA Project #]
,PA.PA_PROJECT_STATUSES.PROJECT_STATUS_NAME AS [PSA Project Status]
,PA.PA_PROJECTS_ALL.CREATION_DATE AS [PSA Project Creation Date]
,PA.PA_PROJECTS_ALL.CREATED_BY
,PA.PA_PROJECTS_ALL.LAST_UPDATE_DATE AS [PSA Project Last Update Date]
,isnull (Pro_manager.FULL_NAME, 'Not Assigned') AS [PSA Project Manager]
-- TopTask
	,T_ORG.geo AS [PSA TopTask Delivery Geo]
	,T_ORG.area AS [PSA TopTask Delivery Area]
	,T_ORG.region AS [PSA TopTask Delivery Region]
	,PA.PA_TASKS.TASK_NUMBER AS [PSA TopTask #]
	,PA.PA_TASKS.TASK_NAME AS [PSA TopTask Name]
	,PA.PA_TASKS.WBS_LEVEL AS [PSA TopTask Structure Class #]
	,PA.PA_TASKS.TASK_ID AS [PSA TopTask ID#]
			,isnull (TopTaskPerson.FULL_NAME, 'Not Assigned') AS [PSA TopTask Manager]
		,TopTaskEle.LAST_UPDATE_DATE AS [PSA TopTask Status Date]
		,ISNULL (TopTaskEle.DESCRIPTION, '') AS [PSA TopTask Overview]
			,ISNULL (UDA_Fields.C_EXT_ATTR1, '') AS [PSA TopTask SO#]
			,ISNULL (UDA_Fields.C_EXT_ATTR2, '') AS [PSA TopTask LineItem#]
			,ISNULL (UDA_Fields.C_EXT_ATTR3, '') AS [PSA TopTask SO Line Quantity]
			,ISNULL (UDA_Fields.C_EXT_ATTR4, '') AS [PSA TopTask Item Name]
			,ISNULL (UDA_Fields.C_EXT_ATTR5, '') AS [PSA TopTask Item Desc]
			,ISNULL (UDA_Fields.C_EXT_ATTR27, '') AS [PSA TopTask Quote#]
			,TopTaskStatus.PROJECT_STATUS_NAME AS [PSA TopTask Status]
			,isnull (Pcomplet.progress_comment, '') as [PSA TopTask Progress Comment]
				,isnull (TopTaskStatusChanger.FULL_NAME, '') AS [PSA TopTask Status Changed From]
	 ,pa.pa_proj_elem_ver_schedule.scheduled_start_date AS [PSA TopTask Scheduled Start Date]
 ,pa.pa_proj_elem_ver_schedule.scheduled_finish_date AS [PSA TopTask Scheduled Finish Date]
 ,pa.pa_proj_elem_ver_schedule.estimated_start_date AS [PSA TopTask Estimated Start Date]
 ,pa.pa_proj_elem_ver_schedule.estimated_finish_date AS [PSA TopTask Estimated Finish Date]
		,GLPost.gl_posted_date AS [PSA TopTask GL POSTED DATE]
 ,CASE 
 WHEN UPPER (task_uda.c_ext_attr11) IN ('EDOK', 'EDNOTREQ')
 AND UPPER (task_uda.c_ext_attr12) IN ('SDOK', 'SDNOTREQ')
 AND UPPER (task_uda.c_ext_attr13) IN ('WCFOK', 'WCFNOTREQ')
 THEN 'PASS'
 WHEN task_uda.c_ext_attr11 IS NULL
 OR task_uda.c_ext_attr12 IS NULL
 OR task_uda.c_ext_attr13 IS NULL
 THEN 'NULL'
 ELSE 'FAIL'
 END as [PSA TopTask Audit Status]
 ,task_uda.c_ext_attr16 as [PSA TopTask Audit Comment]
		-- Task Expenditures
		,TopEXP.[Qbh] AS [PSA TopTask Business Hours]
		,TopEXP.[Qtt] AS [PSA TopTask Travel Time]
		,TopEXP.[Qnbh]AS [PSA TopTask Non Business Hours]
		,TopEXP.[Qpd] AS [PSA TopTask Planning/Documentation]
		,TopEXP.[Q] AS [PSA TopTask Total Hours]
		,TopLTS.[Last Time Submitted] AS [PSA TopTask Last Time Submitted]
 
-- SubTask
, isnull (SubTasks.TASK_NUMBER, '') AS [PSA SubTask #]
			,isnull (SubTaskPerson.FULL_NAME, '') AS [PSA SubTask Manager]
-- 		,SubTaskEle.LAST_UPDATE_DATE AS [PSA SubTask Status Date]
--		,isnull (SubTaskEle.DESCRIPTION, '') AS [PSA SubTask Overview]
--		,Isnull (SubTaskStatus.PROJECT_STATUS_NAME, '') AS [PSA SubTask Status]
--		,isnull (SubTaskStatusChanger.FULL_NAME, '') AS [PSA SubTask Status Changed From]
--		,isnull (PcompletSub.progress_comment, '') as [PSA SubTask Progress Comment] 
		,pa_proj_elem_ver_schedule_sub.scheduled_start_date AS [PSA SubTask Scheduled Start Date]
		,pa_proj_elem_ver_schedule_sub.scheduled_finish_date AS [PSA SubTask Scheduled Finish Date]
		,pa_proj_elem_ver_schedule_sub.estimated_start_date AS [PSA SubTask Estimated Start Date]
		,pa_proj_elem_ver_schedule_sub.estimated_finish_date AS [PSA SubTask Estimated Finish Date] 
 
		-- Task Expenditures
		,SubEXP.[Qbh] AS [PSA SubTask Business Hours]
		,SubEXP.[Qtt] AS [PSA SubTask Travel Time]
		,SubEXP.[Qnbh]AS [PSA SubTask Non Business Hours]
		,SubEXP.[Qpd] AS [PSA SubTask Planning/Documentation]
		,SubEXP.[Q] AS [PSA SubTask Total Hours]
		,SubLTS.[Last Time Submitted] AS [PSA SubTask Last Time Submitted]
 
 
 
FROM PA.PA_PROJECTS_ALL 
-- Additional Project Informations 
LEFT OUTER JOIN PA.PA_PROJECT_STATUSES ON PA.PA_PROJECTS_ALL.PROJECT_STATUS_CODE = PA.PA_PROJECT_STATUSES.PROJECT_STATUS_CODE
	-- Project Manager
	LEFT OUTER JOIN 
			(SELECT PROJECT_ID,Pro_managerNames.FULL_NAME
				FROM apps.pa_project_players 
					LEFT OUTER JOIN 
						(SELECT PERSON_ID, FULL_NAME
 FROM HR.PER_ALL_PEOPLE_F AS PER_ALL_PEOPLE_F_1
 WHERE (EFFECTIVE_START_DATE &lt;= GETDATE()) AND (EFFECTIVE_END_DATE &gt;= GETDATE())) AS Pro_managerNames 
					ON apps.pa_project_players .PERSON_ID = Pro_managerNames.PERSON_ID
				WHERE PROJECT_ROLE_TYPE LIKE 'PROJECT MANAGER') AS Pro_Manager 
		ON PA.PA_PROJECTS_ALL.PROJECT_ID = Pro_Manager.PROJECT_ID
 
-- TopTasks
INNER JOIN	PA.PA_TASKS ON PA.PA_PROJECTS_ALL.PROJECT_ID = PA.PA_TASKS.PROJECT_ID 
	-- Organization
	LEFT OUTER JOIN
 (SELECT hou3.NAME AS geo, hou1.NAME AS area, hou2.ORGANIZATION_ID, hou2.NAME AS region
 FROM HR.PER_ORG_STRUCTURE_ELEMENTS AS pose2 
									INNER JOIN
									 HR.HR_ALL_ORGANIZATION_UNITS AS hou3 
										ON pose2.ORGANIZATION_ID_PARENT = hou3.ORGANIZATION_ID 
									INNER JOIN
 HR.HR_ALL_ORGANIZATION_UNITS AS hou1 
									INNER JOIN
 HR.PER_ORG_STRUCTURE_ELEMENTS AS pose1 
										ON hou1.ORGANIZATION_ID = pose1.ORGANIZATION_ID_PARENT 
									INNER JOIN
 HR.HR_ALL_ORGANIZATION_UNITS AS hou2 
										ON pose1.ORGANIZATION_ID_CHILD = hou2.ORGANIZATION_ID 
										ON pose2.ORGANIZATION_ID_CHILD = pose1.ORGANIZATION_ID_PARENT) AS T_ORG 
		ON PA.PA_TASKS.CARRYING_OUT_ORGANIZATION_ID = T_ORG.ORGANIZATION_ID 
	-- UDA Fields
	LEFT OUTER JOIN (Select * FROM PA.PA_PROJECTS_ERP_EXT_B) as UDA_Fields ON PA.PA_TASKS.Task_id = UDA_Fields.proj_element_id
	-- TopTask Manager
	LEFT OUTER JOIN
 (SELECT PERSON_ID, FULL_NAME
 FROM HR.PER_ALL_PEOPLE_F
 WHERE (EFFECTIVE_START_DATE &lt;= GETDATE()) AND (EFFECTIVE_END_DATE &gt;= GETDATE())) AS TopTaskPerson 
		ON PA.PA_TASKS.TASK_MANAGER_PERSON_ID = TopTaskPerson.PERSON_ID 
 
								-- Task Status Descriptions and Comments for TopTasks
								LEFT OUTER JOIN pa.pa_proj_elements AS TopTaskEle 
									ON PA.PA_TASKS.TASK_ID = TopTaskEle.proj_element_id
											-- TopTask Status Namensauflösung
											LEFT OUTER JOIN (Select PROJECT_STATUS_CODE,PROJECT_STATUS_NAME FROM PA.PA_PROJECT_STATUSES) AS TopTaskStatus 
												ON TopTaskEle.STATUS_CODE = TopTaskStatus.PROJECT_STATUS_CODE
	-- Project Element Versions
	LEFT OUTER JOIN pa.pa_proj_element_versions ON pa.pa_tasks.Task_ID = pa.pa_proj_element_versions.PROJ_ELEMENT_ID
					-- ELEMENT VERSION ID
					Left Outer JOIN pa.pa_proj_elem_ver_schedule 
							ON pa.pa_proj_element_versions.ELEMENT_VERSION_ID = pa.pa_proj_elem_ver_schedule.ELEMENT_VERSION_ID 
							AND pa.pa_proj_element_versions.PROJECT_ID = pa.pa_proj_elem_ver_schedule.PROJECT_ID
 
											-- Name of Status changer
											LEFT OUTER JOIN (SELECT PERSON_ID, FULL_NAME
												 FROM HR.PER_ALL_PEOPLE_F
														 WHERE (EFFECTIVE_START_DATE &lt;= GETDATE()) AND (EFFECTIVE_END_DATE &gt;= GETDATE())) AS TopTaskStatusChanger 
												ON TopTaskEle.LAST_UPDATED_BY = TopTaskStatusChanger.Person_ID
 
		-- Toptask Progress Comment
		LEFT OUTER JOIN
		(Select * FROM pa.pa_percent_completes Where current_flag LIKE 'Y') AS Pcomplet ON pa.pa_tasks.Task_ID = Pcomplet.task_id
		-- GL Post date
		Left Outer Join (SELECT rctl.INTERFACE_LINE_ATTRIBUTE6, rctlg.GL_POSTED_DATE AS gl_posted_date
		FROM apps.ra_customer_trx_lines_all AS rctl INNER JOIN
 apps.RA_CUST_TRX_LINE_GL_DIST_ALL AS rctlg ON rctl.CUSTOMER_TRX_LINE_ID = rctlg.CUSTOMER_TRX_LINE_ID AND 
 rctl.CUSTOMER_TRX_ID = rctlg.CUSTOMER_TRX_ID AND rctl.CUSTOMER_TRX_LINE_ID = rctlg.CUSTOMER_TRX_LINE_ID INNER JOIN
 apps.ra_customer_trx_all AS rcth ON rctl.CUSTOMER_TRX_ID = rcth.CUSTOMER_TRX_ID 
		WHERE (rctlg.ACCOUNT_CLASS = 'REV') AND (rcth.TRX_DATE IS NOT NULL) AND (rctlg.[PERCENT] = 100) AND 
 (rctl.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY') AND (rctl.SALES_ORDER_SOURCE = 'ORDER ENTRY') AND (rctl.LINE_TYPE = 'LINE') AND 
 (rctlg.POSTING_CONTROL_ID &lt;&gt; - 3)) AS GLPost ON PA.PA_Tasks.ATTRIBUTE8 = GLPost.INTERFACE_LINE_ATTRIBUTE6
 
 
		-- TopTask Audit /* +++Testing+++ */
		LEFT OUTER JOIN (SELECT uda.project_id, uda.proj_element_id, uda.c_ext_attr1,
 uda.c_ext_attr2, uda.c_ext_attr3, uda.c_ext_attr4,
 uda.c_ext_attr5, c_ext_attr11,c_ext_attr12,c_ext_attr13,
 c_ext_attr16, ooh.ship_to_org_id, ooh.invoice_to_org_id,
 ooh.salesrep_id
 FROM PA.pa_projects_erp_ext_b uda,
 apps.oe_order_headers_all ooh,
 apps.ego_attr_groups_v eagv
 WHERE uda.c_ext_attr1 = ooh.order_number
 AND uda.attr_group_id = eagv.attr_group_id
 AND eagv.attr_group_name = 'Sales_Order_information') AS task_uda
		ON PA.PA_TASKS.task_id = task_uda.proj_element_id
 
		-- TopTask Hours
		LEFT OUTER JOIN (SELECT TASK_ID, 
 SUM(CASE [Expenditure_type] WHEN 'Business Hours' Then Quantity ELSE 0 END) As [Qbh], 
 SUM(CASE [Expenditure_type] WHEN 'Travel Time' Then Quantity ELSE 0 END) As [Qtt], 
 SUM(CASE [Expenditure_type] WHEN 'Non Business Hours' Then Quantity ELSE 0 END) As [Qnbh],
 SUM(CASE [Expenditure_type] WHEN 'Planning/Documentation' Then Quantity ELSE 0 END) As [Qpd],
		 SUM(Quantity) As [Q]
		FROM pa.pa_expenditure_items_all GROUP BY TASK_ID) as TopEXP
		ON PA.PA_TASKS.TASK_ID = TopEXP.TASK_ID
 
		-- TopTask Last Time Submitted
		LEFT OUTER JOIN (Select TASK_ID AS Task_ID5, MAX (EXPENDITURE_ITEM_DATE) as [Last Time Submitted]
		FROM pa.pa_expenditure_items_all
		WHERE Expenditure_type LIKE'Business Hours' 
		OR Expenditure_type LIKE'Travel Time'
		OR Expenditure_type LIKE'Non Business Hours'
		OR Expenditure_type LIKE'Planning/Documentation'
		GROUP BY TASK_ID) as TopLTS
		ON PA.PA_TASKS.TASK_ID = TopLTS.TASK_ID5
 
 
 
	-- SubTasks
	LEFT OUTER JOIN (Select * FROM PA.PA_TASKS) AS SubTasks	ON	PA.PA_TASKS.TASK_ID = SubTasks.Top_Task_ID and SubTasks.TASK_NUMBER != PA.PA_TASKS.TASK_NUMBER
					LEFT OUTER JOIN
 (SELECT PERSON_ID, FULL_NAME
 FROM HR.PER_ALL_PEOPLE_F
 WHERE (EFFECTIVE_START_DATE &lt;= GETDATE()) AND (EFFECTIVE_END_DATE &gt;= GETDATE())) AS SubTaskPerson 
						ON SubTasks.TASK_MANAGER_PERSON_ID = SubTaskPerson.PERSON_ID 
 
								-- Task Status Descriptions and Comments for SubTasks
								LEFT OUTER JOIN pa.pa_proj_elements AS SubTaskEle 
									ON SubTasks.TASK_ID = SubTaskEle.proj_element_id
											-- TopTask Status Namensauflösung
											LEFT OUTER JOIN (Select PROJECT_STATUS_CODE,PROJECT_STATUS_NAME FROM PA.PA_PROJECT_STATUSES) AS SubTaskStatus 
												ON SubTaskEle.STATUS_CODE = SubTaskStatus.PROJECT_STATUS_CODE
											-- Name of Status changer
											LEFT OUTER JOIN (SELECT PERSON_ID, FULL_NAME
												 FROM HR.PER_ALL_PEOPLE_F
														 WHERE (EFFECTIVE_START_DATE &lt;= GETDATE()) AND (EFFECTIVE_END_DATE &gt;= GETDATE())) AS SubTaskStatusChanger 
												ON SubTaskEle.LAST_UPDATED_BY = SubTaskStatusChanger.Person_ID
	-- Project Element Versions
	LEFT OUTER JOIN (Select * FROM pa.pa_proj_element_versions) as pa_proj_element_versions_sub ON SubTasks.Task_ID = pa_proj_element_versions_sub.PROJ_ELEMENT_ID
					-- ELEMENT VERSION ID
					Left Outer JOIN (Select * FROM pa.pa_proj_elem_ver_schedule) AS pa_proj_elem_ver_schedule_sub 
							ON pa_proj_element_versions_sub.ELEMENT_VERSION_ID = pa_proj_elem_ver_schedule_sub.ELEMENT_VERSION_ID 
							AND pa_proj_element_versions_sub.PROJECT_ID = pa_proj_elem_ver_schedule_sub.PROJECT_ID
		-- Subtask Progress Comment
		LEFT OUTER JOIN
		(Select * FROM pa.pa_percent_completes Where current_flag LIKE 'Y') AS PcompletSub ON SubTasks.Task_ID = PcompletSub.task_id
		
 
		-- SubTask Hours
		LEFT OUTER JOIN (SELECT TASK_ID, 
 SUM(CASE [Expenditure_type] WHEN 'Business Hours' Then Quantity ELSE 0 END) As [Qbh], 
 SUM(CASE [Expenditure_type] WHEN 'Travel Time' Then Quantity ELSE 0 END) As [Qtt], 
 SUM(CASE [Expenditure_type] WHEN 'Non Business Hours' Then Quantity ELSE 0 END) As [Qnbh],
 SUM(CASE [Expenditure_type] WHEN 'Planning/Documentation' Then Quantity ELSE 0 END) As [Qpd],
		 SUM(Quantity) As [Q]
		FROM pa.pa_expenditure_items_all GROUP BY TASK_ID) as SubEXP
		ON PA.PA_TASKS.TASK_ID = SubEXP.TASK_ID
 
		-- SubTask Last Time Submitted
		LEFT OUTER JOIN (Select TASK_ID, MAX (EXPENDITURE_ITEM_DATE) as [Last Time Submitted]
		FROM pa.pa_expenditure_items_all
		WHERE Expenditure_type LIKE'Business Hours' 
		OR Expenditure_type LIKE'Travel Time'
		OR Expenditure_type LIKE'Non Business Hours'
		OR Expenditure_type LIKE'Planning/Documentation'
		GROUP BY TASK_ID) as SubLTS
		ON SubTasks.TASK_ID = SubLTS.TASK_ID
 
Where PA.PA_TASKS.WBS_LEVEL Like 1	
</code></pre>
</div>

<div>
<div class="content wysiwyg-content">
Hi all, 
 
Basically I would like to understand a bit more about how to track and interpret 
Error messages in SQL Management Studio. 
 
Specially in this case&amp; 
Ran a sql query which worked day by day perfectly fine 
Mysteriously since yesterday I am facing this error message 
 
Msg 8114, Level 16, State 5, Line 1 
Error converting data type nvarchar to numeric. 
 
So there is a converting issue which werent there a view hours ago. 
I have 80 columns in the sql query how can I easily find out which one it is and 
What the reason for these change was? 
 
Thanks for your Help! 

</div>
</div>

Hi all,

Basically I would like to understand a bit more about how to track and interpret 
Error messages in SQL Management Studio.

Specially in this case& 
Ran a sql query which worked day by day perfectly fine 
Mysteriously since yesterday I am facing this error message

Msg 8114, Level 16, State 5, Line 1
Error converting data type nvarchar to numeric.

So there is a converting issue which werent there a view hours ago.
I have 80 columns in the sql query how can I easily find out which one it is and 
What the reason for these change was? 

Thanks for your Help! 


Error Tracking in Management Studio

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.