Đang Thực Hiện

Transform SQL query to an updating stored procedure

I have a SQL query that returns 2 columns whice are ID's from 2 tables on a one to one relationship.

I need this to update two table in a MS SQL database using a stored procedure, looping through each row of the query. The query currently matches 1:1 even if there is a dupe and it is important that it only updates 1 matching entry in each table even if there are dupes.

Please see attached sample query and notes.

Kỹ năng: SQL

Xem thêm: sql transform query procedure, n query, transform query stored procedure, updating, stored, sql query, query table, sql database relationship, database updating, sql stored, database procedure, sql entry, sql update, update database sql, sql database tables, need sql query, sample sql database, update query, tables stored sql, query database, dupes, sql stored procedure table, sql table procedure, update sql, updating stored procedure

Về Bên Thuê:
( 1 nhận xét ) mayfair, United Kingdom

Mã Dự Án: #1011795

Đã trao cho:

saamorim

I've got the query/stored procedure ready. Regards

£20 GBP trong 0 ngày
(6 Đánh Giá)
3.9

2 freelancer đang chào giá trung bình £20 cho công việc này

parthiban86

Lets start to work now please check PM details

£20 GBP trong 0 ngày
(0 Đánh Giá)
0.0