On Mon, Sep 25, 2017 at 9:33 AM, Stephen Russell srussell705@gmail.com wrote:
Is the ID column the first one in your list of insert columns? SPri
You can rt click on the table and go to Script Table as, then use insert to, and have it write out the plain Jane code for this table's insert.
Yes, SPri is the PK and first column in the table being inserted in to.
The plain jane is what I used as the template to create the query, then tried modifying it to use the values from the FMDFSRQ table.
mj
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---