Terminé

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.

Compétences : SQL

en voir plus : 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

Concernant l'employeur :
( 1 commentaire ) mayfair, United Kingdom

Nº du projet : #1011795

Décerné à:

saamorim

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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% GBP en 0 jours
(6 Commentaires)
3.9

2 freelance font une offre moyenne de £20 pour ce travail

parthiban86

Lets start to work now please check PM details

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 0 jours
(0 Commentaires)
0.0