fwob04 (11/7/2012)
It didn't occur to me to verify the datatypes were the same, good point. Unfortunately it didn't help this time as the datatype is int.
Just checking here.
I did some research and learned enough about triggers to be fairly confident that there are none associated with archiveID in any of the tables I am working with.
Triggers don't work on a column as you are suggesting. If there are triggers on these tables that very well could be the issue.
I am certainly willing to help you here but I need to get some more information from you in order to be able to help. I see that you are pretty new around here so you probably don't know the type of information required to help. We need to see ddl (create table statements including ALL triggers, constraints, indexes etc), some sample data (insert statements). There is no need to post actual data but you should post enough to cover the issue at hand. If you take a look at the first link in my signature it will explain the best practices for posting questions.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/