I wasn't requesting any more help. The in works and works everytime. When I requested the help, the original query was returning an error for me every time I ran...

I have seen it work, but I have also seen it fail. I don't know why. It was really very strange but putting the IN made it work 100% of...

It was failing every time with a message about not being able to handle multiple trues in the where clause with an OR. The where in clause works well.

I am using SQL Server 2005.

When both id's are found the code does not work. SQL Server showed an error when both conditions were true. So the code did not work if there...

Thanks Matt - the Where in clause worked perfectly! I really appreciate your help.

Thanks I am going to try the where id in (1,2,3).

I know that code doesn't have a subquery, I stated that I also tried a subquery using where exists. I have done something like this in Oracle, but never with...

Thanks.

How about if I want to do that for multiple records in one update statement. Will I need a loop or can I use an OR?