okay, let's use a perm table, how do I get the data that will not insert to go to another table for later correction?

either one will work temp or perm, I just want to be able to get the data in and deal with the one line that would not go in later....

Thanks but a solution was check. A case stmt was the trick.

I tried
where [Year]=Year(GetDate())-1
AND [Month]=Month(GetDate())-1;

No results came back

I also...

create table dbo.Sales 

(

[SalesID]