Post reply

Msg 207, Level 16, State 1, Line 119 Invalid column name 'Sales Doc Nbr'

  • February 4, 2014 at 10:44 am

    #303685

    0

    down vote

    favorite

    I have a problem with my Merge statement (SCD type 1). I am getting the error: Msg 207, Level 16, State 1, Line 119 Invalid column name 'Sales Doc Nbr'. although the column exist in source and target tables and the spelling is correct.

    Any ideas?

  • February 4, 2014 at 12:18 pm

    #1685981

    Golden_eye (2/4/2014)

    0

    down vote

    favorite

    I have a problem with my Merge statement (SCD type 1). I am getting the error: Msg 207, Level 16, State 1, Line 119 Invalid column name 'Sales Doc Nbr'. although the column exist in source and target tables and the spelling is correct.

    Any ideas?

    Did you enclose the name in brackets?

    e.g., [Sales Doc Nbr]

    Thanks

    John.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply