You need a bigger hammer.
What are the rules for the PKey? It doesn't make sense that you would generate that value and not have the db create it for you. Is it an INT? Can you just do: INSERT INTO [dbo].[FMDFPRI] (created, edited) values ( '20161201092101946CSS01 ' , '20161201092101946CSS02 ' )
On Mon, Sep 25, 2017 at 12:16 PM, M Jarvis brewdaddy@gmail.com wrote:
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
-- Matt Jarvis Eugene, Oregon USA
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]