Good Afternoon
I am using MSSQL and have a puzzler!
I have a table, STK_Stock, which has 783 records, I have a second table, STK_Location which is empty. I need to be able to create a script that will create a record on STK_Location per STK_Stock record, however, I also need to set the values for every field on the STK_Location table as part of the insert / update! To complicate matters,, some of the data that needs to be included within the insert / update comes from a 3rd table, STK_Stock2!
The tables are linked by the STKCode key on the STK_Stock table, the LOC_Stock_Code on the STK_Location table and the STKCode2 on the STK_Stock2 table.
I hope that is clear if somewhat convoluted and any assistance will be gratefully received!
Kind regards
Steve
I am using MSSQL and have a puzzler!
I have a table, STK_Stock, which has 783 records, I have a second table, STK_Location which is empty. I need to be able to create a script that will create a record on STK_Location per STK_Stock record, however, I also need to set the values for every field on the STK_Location table as part of the insert / update! To complicate matters,, some of the data that needs to be included within the insert / update comes from a 3rd table, STK_Stock2!
The tables are linked by the STKCode key on the STK_Stock table, the LOC_Stock_Code on the STK_Location table and the STKCode2 on the STK_Stock2 table.
I hope that is clear if somewhat convoluted and any assistance will be gratefully received!
Kind regards
Steve