Thank you for the help, I really appreciate it. I have updated my code, but I am still receiving the error regarding the select statement towards the end of my...

As for defining the purpose of this script a little more clearly, this whole thing is being used in an incredibly simple manner. I know that giving users the power...

Thanks everyone for the comments! And again I apologize for my lack of knowledge on the subject, I am very new to sql and these forums, thanks for being patient...

The countSSN procedure runs fine, but what I am trying to do is actually physically replace the values in the table with these count values generated by the countSSN procedure....

I don't think I'm being clear enough, what I want is the procedure to run so it will replace all of the table values under ssn with COMPLETELY DIFFERENT count...

use Brett_Test

GO

if exists (select * from sysobjects where type = 'P' and name = 'countSSN')

drop procedure countSSN

GO

create procedure countSSN

as

set nocount on;

...

Thank you for your input!

SSCommitted,

There is no real correlation between the SSN and the new value ........ The purpose of this is to mask the SSN because it is considered...