SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO


ALTER  procedure randometer (@table_name varchar(255), @sel_date varchar(6),
 @type_code varchar(1)  ) As

--create a recency column
exec ('append_recency_column ''' + @table_name + ''',''' + @sel_date + ''',''' + @type_code + '''' )

--create our nth_guide varchar(11) column
exec ('alter table ' + @table_name + ' add nth_guide varchar(11)')

--set our nth_guide = recency + reverse of zip4
exec ('
update ' + @table_name + 
' set nth_guide = recency + reverse(zip4)
where zip4 != ''''')

--set our nth_guide = recency + reverse of right 4 of zip
exec('
update ' + @table_name + 
' set nth_guide = recency + reverse(right(zip,4))
where zip4 = ''''')


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO