crackedcornjimmy (4/5/2012)
I mentioned in the question that I am using SQL 2000. Unfortunately, PERSISTED is not available in SQL 2000. It wasn't introduced until 2005+.
Sorry I missed that you mentioned 2000 and were in a 2000 forum. I see so few posts for 2000 I always assume 2005+.
I just noticed that you are decoding and then re-encoding the data in the column. Why are you doing both? If it is already Encoded you shouldn't need to do anything.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question