I guess that would be a good detail to know. The dates in the source Data are in a format like 'Jan-08' or 'MMM-YY' and the field is an nvarchar...

Great thanks for the info. This really confirms what I had thought. Just wanted to make sure there wasn't a major gotcha someplace on this issue.

Unfortunately the Dev team...

It works!!!

I went with the original solution. It got what I needed but am going to try out Jeff's cursor'less version just to see how it works.

Thanks for the help...

I'm getting closer but it still has issues when I run it.

Still getting

Msg 137, Level 15, State 1, Line 1

Must declare the scalar variable "@BUGCOUNT".

Total Defects in AdventureWorks for 2008...

Thanks for your help on this. I have attempted to rewrite the script using your suggections and am getting closer. this is what I have at this point.

SET ANSI_NULLS ON

SET...