have you tried inverting the order of operations ? :

SELECT @intMax = ISNULL(cast(MAX(SUBSTRING(event_num,5,6))as integer) +1,1)

FROM Events e

     join Prod_Units pu on e.pu_id = pu.pu_id

WHERE pu.pl_id = @intPlId and len(event_num) =...

At this point who cares?

BTW: do you have a boss? ( or a job for that matter ? ) 

No,

What I meant is that if you are going to use the way that the poster issued all expressions involved should either be of the same type or implicitely converrtible otherwise...

The problem may be a context issue. You may be runing a batch and you want to make sure that it works reapeatedly then is an easy way to do...

you should use the searched way instead:

CASE WHEN @CheckBDate  = 0 THEN @NullBDate ELSE @BDate END

because the types of the expresssions are not the same

if not object_id ('temp..TempTable') is null

begin

 drop table #TempTable

end

but if you use this syntax:

rs.open "EXEC mySPname " & param1 & ", " & param2 ....

you also get BATCH call and won't enjoy RPC call speed benefits (which may not...

Ahh the joy of guessing ... we will never know what he actually wanted? ... unless the poster replies back

Smileys are good

     ' FROM...

can you post some data samples ?

this is a wild guess

Update Table Set Fld = '\\server2\folder5\' + Right(Fld,charindex('\',1,reverse(fld)) -1)

Are you really saying that?

There is no last or first on a set! There is no guarrantie on order on a set. sometimes...

BE Careful with this code:

...

-- Insert patient

   INSERT ...

   SELECT @errorcode = @@Error

   IF @errorcode > 0 BEGIN

      -- Insert successful, commit it

      SELECT @ID = @@IDENTITY

...

It is flawed. You must...

>>...the last (just in case the newbies come up on this thread ).<<

Well, the problem is that in SQL there is no concept of...