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')