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 <[email protected]> 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]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/cajidmyjej+wzovozhg9+mud2bvp5gum6bfhy9kmoxkbrv2v...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
