This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 2%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENW%3C/text%3E%3C/svg%3E)
Hello, I was trying to create a new column which is transferred the data from staging to our final table via store procedure. I keep on alter different things in the script but it still come up with error saying the column not valid. the AssigneeIDFK under the attached ( the one comment out was the column which I would like to put them into our final table)
where is your staging located? are they both in synapse? also did you checked the data type? why is this getting error?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
@Nick Wong
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Hello @VINODH KUMAR They are both inside Synapse. would you be able to look into my Code below please? StorePRocedure.txt
@Nick Wong
Based on the code you provided, it seems that the AssigneeIDFK column is commented out. If you want to add this column to your final table, you need to uncomment it in your code. Additionally, make sure that the data type of the AssigneeIDFK column matches the data type of the corresponding column in your staging table.
It's also worth checking if the column name is spelled correctly and that there are no typos or syntax errors in your code. If you're still encountering issues, please provide the exact error message you're receiving, as well as any additional details that may be relevant.