AnsweredAssumed Answered

Renaming Tasks

Question asked by mscann52 on Nov 5, 2014
Latest reply on Nov 6, 2014 by navzjoshi00

Urgent:  I need to rename all Tasks in every project (26,000+) to something generic.  If not an additional headache, I would like to use 5 new names [Planning, Development, Deployment, Release and UAT-will work for the names] and then have the 5 new names repeated until all 26,000+ Tasks names are renamed).  I have started writing a sql...but cannot get it finished! 


The idea I have for the SQL is to convert the Task sequence into a string and replace the names for all sequences ending in 1& 6, 2 & 6, 3 & 8, 4 & 9, 5 & 0 - into the 5 new Task names.


My Preliminary SQL:  update prtask set prname = 'Task Plan' where instr(cast(PRSEQUENCE AS CHAR(8)), 8) IN ('1; '6')