It does seem like a lot of work just to get it to plug into a stored procedure. I was hoping to keep the functionality contained in a central...

Thank you so much! I knew it was something silly but I couldn't come up with the correct syntax.

Hey thanks a lot. I needed a quick turnaround on this and thankfully it works. Peace out.

SSCrazy Eights,

When I try and run your query in Analyzer I get this:

"The column prefix 'DU' does not match with a table name or alias name used in the query."

As...

That's exactly what I have in a separate procedure see below. Is there a way to incorporate the count into the existing procedure?

ALTER ...

Basically I added BEGIN and END and modified the error handling. Here is the corrected and functioning code for the second update statement:

/*** Update Users Acct. Status ***/

/* update...