Awesome...sometimes things in SQL are too simple to comprehend off the bat..lol

I realized that a few minutes ago and did in fact make it varchar(4). Thanks for having my back on that one.

SQL is slowly but surely going...

I got it figured out everyone...Thanks for all your suggestions and ideas. I appreciate it a ton.

The code below is what gave me the right result. I just...

I gave this a try...not seeing any change in the query results...is it the select statement that's the problem...maybe the way I'm assigning the variable and referencing it in the...

ChrisM @ work, that is the what I did to get the last day of the previous month from the current month we're in. Let me know if you...

I added your solution, but I probably didn't get it right cause I got the same result:

declare @seedval int;

update LexingtonBordereau_Seed set seedid = seedid + 1, seeddate = getdate()

select @seedval...

Hey Sean...thanks for helping me out! This is indeed a one time event. I will just use the several statement method. Thanks again!