ErrorID : 0
ErrorSource : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData->EmployeeData.GetData->EmployeeData.GetEmployeeProfile
ErrorMessage: An INSERT EXEC statement cannot be nested.
An INSERT EXEC statement cannot be nested.
Column name or number of supplied values does not match table definition.
Title
select Cast(ID as nvarchar(10)) + '~' + Name1 as Name1 from Title
YesNo
select Cast(ID as nvarchar(10)) + '~' + Name1 as Name1 from YesNo
YesNo
select Cast(ID as nvarchar(10)) + '~' + Name1 as Name1 from YesNo
LanguageIndicator
select Cast(ID as nvarchar(10)) + '~' + Name1 as Name1 from LanguageIndicator
Country
select Cast(ID as nvarchar(10)) + '~' + Name as Name from Country
Gender
select Cast(ID as nvarchar(10)) + '~' + Name1 as Name1 from Gender
SpouseRelationship
select Cast(ID as nvarchar(10)) + '~' + Name1 as Name from SpouseRelationship where ID NOT IN( -1,-1)
SpouseStatus
select Cast(ID as nvarchar(10)) + '~' + Name1 as Name1 from SpouseStatus where ID NOT IN (0,7) Order By Name1 ASC
Country
select Cast(ID as nvarchar(10)) + '~' + Name as Name from Country
EmployeeStatus
select Cast(ID as nvarchar(10)) + '~' + Name1 as Name1 from EmployeeStatus
State
select Cast(ID as nvarchar(10)) + '~' + Name as Name from State where CountryID In (0,1)
State
select Cast(ID as nvarchar(10)) + '~' + Name as Name from State where CountryID In (0,1)