Hello. I use SQL 2005. I have problem :(Error massage: Msg 4104, Level 16, State 1, Procedure ITSM_INCIDENTS_V, Line 2The multi-part identifier "ITSM_INCIDENTS_V.Impact_functionID" could not be bound.SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER VIEW [dbo].[ITSM_INCIDENTS_V] AS SELECT ISNULL(REG_MODIFIED,REG_CREATED) AS TA_PERIOD,INC_OID AS INC_OID,INC_ID AS ID,ISNULL((SELECT DISTINCT PER_NAME FROM ITSM_PERSONS WHERE ITSM_INCIDENTS.inc_requestor_per_oid = ITSM_PERSONS.PER_OID ),'Unknown') AS Requestor,INC_DESCRIPTION AS INC_Description,ISNULL((SELECT DISTINCT rct_name FROM REP_CODES_TEXT WHERE ITSM_INCIDENTS.INC_STA_OID = REP_CODES_TEXT.rct_rcd_oid and (rct_lng_oid IS NULL OR rct_lng_oid = 1049)),'Unknown') AS INC_Status,INC_SOLUTION AS SOLUTION,ISNULL((SELECT DISTINCT ICF_INCIDENTTEXT1 FROM ITSM_INC_CUSTOM_FIELDS WHERE ITSM_INCIDENTS.INC_OID = ITSM_INC_CUSTOM_FIELDS.ICF_INC_OID),'Unknown') AS INC_Manual,ISNULL((SELECT DISTINCT ACC_SHOWNAME FROM REP_ACCOUNTS WHERE ITSM_INCIDENTS.REG_CREATEDBY = REP_ACCOUNTS.ACC_OID ),'Unknown') AS Createdby,ISNULL((SELECT convert(nvarchar,ICF_COD1_OID) FROM ITSM_INC_CUSTOM_FIELDS WHERE ITSM_INCIDENTS.INC_OID = ITSM_INC_CUSTOM_FIELDS.ICF_INC_OID ),'Unknown') AS Impact_functionID, ISNULL((SELECT CDL_NAME FROM ITSM_CODES_LOCALE WHERE ITSM_INCIDENTS_V.Impact_functionID = ITSM_CODES_LOCALE.cdl_cod_oid ),'Unknown') AS Impact_function,ISNULL((SELECT convert(nvarchar(80),icf_duration1) FROM ITSM_INC_CUSTOM_FIELDS WHERE ITSM_INCIDENTS.INC_OID = ITSM_INC_CUSTOM_FIELDS.ICF_INC_OID ),'NULL') AS Service_Delay, -- REG_CREATED AS REG_CREATED,INC_ACTUALSTART AS ACTUALSTART,INC_PLANSTART AS PLANSTART,INC_PLANFINISH AS PLANFINISH,inc_planduration AS PLANDURATION,INC_ACTUALDURATION AS ACTUALDURATION,ISNULL(REG_MODIFIED,'') AS REG_MODIFIED,ISNULL((SELECT WOG_NAME FROM ITSM_WORKGROUPS WHERE ITSM_INCIDENTS.INC_ASSIGN_WORKGROUP = WOG_OID),'Unknown') AS WOG_NAME,ISNULL((SELECT PER_NAME FROM ITSM_PERSONS WHERE ITSM_INCIDENTS.inc_assign_person_to = ITSM_PERSONS.PER_OID),'Unknown') AS assign_person ,ISNULL(INC_ACTUALDURATION,0) AS ACTUAL_DURATION,ISNULL(INC_ACTUALFINISH,'') AS ACTUAL_FINISH,ISNULL(INC_DEADLINE,'') AS DEADLINE,ISNULL((SELECT DISTINCT RCT_NAME FROM REP_CODES_TEXT WHERE ITSM_INCIDENTS.INC_CAT_OID = RCT_RCD_OID and (rct_lng_oid IS NULL OR rct_lng_oid = 1049)),'Unknown') AS CAT_NAME,ISNULL((SELECT DISTINCT CDL_NAME FROM ITSM_CODES_LOCALE WHERE ITSM_INCIDENTS.INC_CLA_OID = ITSM_CODES_LOCALE.CDL_COD_OID and (cdl_lng_oid IS NULL OR cdl_lng_oid = 1049)),'Unknown') AS CLA_NAME, ISNULL((SELECT DISTINCT INI_INFORMATION FROM ITSM_INC_INFORMATION WHERE ITSM_INCIDENTS.INC_OID = ITSM_INC_INFORMATION.INI_INC_OID ),'Unknown') AS Information,ISNULL((SELECT DISTINCT CDL_NAME FROM ITSM_CODES_LOCALE WHERE ITSM_INCIDENTS.INC_PRI_OID = ITSM_CODES_LOCALE.CDL_COD_OID and (cdl_lng_oid IS NULL OR cdl_lng_oid = 1049)),'Unknown') AS PRIORITY_NAME,ISNULL((SELECT DISTINCT CIT_SEARCHCODE FROM ITSM_CONFIGURATION_ITEMS WHERE ITSM_INCIDENTS.inc_cit_oid = ITSM_CONFIGURATION_ITEMS.CIT_OID ),'NULL') AS CI,ISNULL((SELECT DISTINCT CDL_NAME FROM ITSM_CODES_LOCALE WHERE ITSM_INCIDENTS.INC_CLO_OID = ITSM_CODES_LOCALE.CDL_COD_OID and (cdl_lng_oid IS NULL OR cdl_lng_oid = 1049)),'Unknown') AS CLO_CODE,ISNULL((SELECT DISTINCT CDL_NAME FROM ITSM_CODES_LOCALE WHERE ITSM_INCIDENTS.INC_IMP_OID = ITSM_CODES_LOCALE.CDL_COD_OID and (cdl_lng_oid IS NULL OR cdl_lng_oid = 1049)),'Unknown') AS IMPACT_NAME,(CASE WHEN REG_MODIFIED IS NULL THEN 1 ELSE 0 END) AS IS_NEW,(CASE WHEN INC_ACTUALFINISH IS NOT NULL THEN 1 ELSE 0 END) AS IS_CLOSED,(CASE WHEN INC_DEADLINE > INC_ACTUALFINISH THEN 1 ELSE 0 END) AS CLOSED_BEFORE_DEADLINE,(CASE WHEN INC_ACTUALFINISH IS NOT NULL AND REG_MODIFIED IS NULL THEN 1 ELSE 0 END) AS CLOSED_ON_FIRST_CALL,(CASE WHEN ISNULL(REG_MODIFIED,REG_CREATED) > INC_DEADLINE THEN 1 ELSE 0 END) AS DEADLINE_EXPIRED,(CASE WHEN (1=1) THEN 'All Device' END) as TargetName FROM ITSM_INCIDENTS
Help Msg 4104, Level 16, State 1
Posted - 2008-12-03 : 08:48:08
