ronmoses (8/3/2010)
Yep, I've been bitten by that one more than once. Until you learn that int/int "gotcha" it can be nearly impossible to troubleshoot a script that is experiencing it. Good question.
Unfortunately, this gets me all the time. I know about the issue, I know the workarounds but it still fails to sink in until after I run the query and don't get the expected results. I failed again when answering the QOTD.