When I execute the query, it returns this;
Msg 207, Level 16, State 1, Line 14
Invalid column name 'RT_MCP_Name'.
Msg 207, Level 16, State 1, Line 15
Invalid column name 'RT_MCP_State'.
Msg 207, Level 16, State 1, Line 16
Invalid column name 'RT_MCP_Alarm_Text'.
Msg 207, Level 16, State 1, Line 17
Invalid column name 'RT_MCP_Alarm_Text'.
Msg 207, Level 16, State 1, Line 18
Invalid column name 'RT_MCP_Date_Time'.
Msg 207, Level 16, State 1, Line 19
Invalid column name 'RT_MCP_Bit_State'.
Msg 207, Level 16, State 1, Line 20
Invalid column name 'RT_MCP_Date_Time'.
Msg 207, Level 16, State 1, Line 20
Invalid column name 'RT_MCP_Alarm_Text'.
Msg 207, Level 16, State 1, Line 20
Invalid column name 'RT_MCP_Name'.
Msg 207, Level 16, State 1, Line 20
Invalid column name 'RT_MCP_State'.
Msg 207, Level 16, State 1, Line 20
Invalid column name 'RT_MCP_Alarm_Text'.
Msg 207, Level 16, State 1, Line 20
Invalid column name 'RT_MCP_Bit_State'.
I am guessing I need to change something else also.
Thanks,
Brian
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner