Insert data from table1 to table2 depending on user_id and record_id

So I need to insert some records from table1 to table2 depending on their user_id (PVKEY) and record_id (CNKEY). Just to explain better, every user has his own unique user_id (PVKEY) and every record has his own record_id (CNKEY). One user can have couple of records but everytime when the new record is added it needs to get new record_id (CNKEY) Everytime I try to insert I get message:

"Cannot insert the value NULL into column 'CNKEY', table 'Progress.dbo.CONTHIST'; column does not allow...

Insert data from table1 to table2 depending on user_id and record_id

from Databases http://ift.tt/24F1eiG
via IFTTT

Share :

Tweet

✚

Related Post

• Selling DumpsDumps and Cvv prices depends on country and card type. Please contact me for further details. I got
• Combine data from two rows into oneWhen I do a query, I get the following results (see attached image). I would like the January rows
• MySQL CONCAT, HAVING and JOINhi can this be use all together? here is my query: SELECT CONCAT(fullname," ",address1," ",city,"
• How the postgreSQL/postGIS database implemented OGC standards?For one work I needed to understand How the postgreSQL/postGIS database implemented OGC standards..
• sql query to increase/decrease priceHi there, I need to run a basic mysql query to increase all the prices in "price field" in my tabl
• ElectroCRUD - Young MySQL CRUD AppNo coding is required; Create basic CRUD (Create, Read, Update, Delete) for your MySQL Database in