thanks

OK it was stupid

fixing the lines

begin

if @monthend = 'Y'

...

Thanks for all help! I finally got my ultimate goal which was to take the SELECT statement and use it to create a UPDATE SQL Statement which updates a...

Thanks for the reply! I ran the query and while I was running it my CPUs spiked to 100%. 28000 records in test table. The way the...

Ok, I got past that problem, now I have a new one.

I have used the wizard and 'successfully' created the

DISTRIBUTOR (on machine B). Now I go to Machine...

I tried to configure my dev server as distrubutor and ran into a error that I dont know what to do about. "SQL Server Enterprise Manager could not configure...

I have not done much yet. I have 2 servers, the 1st I will call Prod, and 2nd I will call Dev. Prod I want to be the Publisher,...