• 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