Ummm, didn't realize I had to rebuild.... thanks.

Still can't connect using SSMS to sql2000.  Looked under sql native client configuration - tcpip is enabled.  Looked under aliases - ip and...

Well, I guess the paranoia worked.  My checklist seemed to cover most everything.  Upgrade went through without a hitch - no errors.  Took 3 tries for all components of the...

Yep, you understand the scenario.  Hmmm, I would have thought that executing the code once a month in a stored procedure was considered 'better' than adding a static lookup table...

Went with this, but is there a way to do in where clause?

DECLARE

@mycheck int

IF @mon=1

set @mycheck = 216

else if @mon=2

set @mycheck = 244

.....

where

....

dateDiff(day,v.dateService,@myDate) < @mycheck

Geez, well that would work, wouldn't it?  thanks.  Trying to make it too hard.

JB

Crud!  Found it - must set nocount on in stored procedure for the code to run.  Only change and everything works fine.