Đã hoàn thành

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 nhiều hơn: sql transform query procedure, update stored procedure sql query, n query, transform sql query updating stored procedure, transform query stored procedure, updating, stored, SQL Query, query table, sql database relationship, database updating, query query, SQL stored, database procedure, sql entry, sql update, update database sql, sql database tables, need sql query, sql query sql query, sample sql database, update query, tables stored sql, stored procedure xml type sql, query database

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

ID dự án: #1011795

Được trao cho:


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

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

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


Lets start to work now please check PM details

£20 GBP trong 0 ngày
(0 Nhận xét)