Actually, I came up with a brute force method that seems to do the job. Thanks....
INSERT INTO [dbo].[FMDFPRI] ([SPri]) select distinct p.priority from fmdfsrq p where p.priority <> '' GO
update fmdfpri set descr = Spri , created = '20161201092101946CSS01 ' , edited = '20161201092101946CSS02 ' GO