Convert SQL Table to new format.
$100-300 USD
货到付款
Hi,
We have a table holding data in a format and want to run a SQL job that will process that data and insert it into a different table in a different format.
The "source" table is normalized and we want to insert it into a non-normalized "destination" table.
Look at the DB schema in the attached file. We want to:
a. For each value of the RESPONSIBLEPARTY column in the "source" table, create one entry in the "destination" table with the same values for RESPONSIBLEPARTY, PHONENUMBER, SUBSNUMBER, LOB, LANG and RECERTDATE.
b. Then for each different n value of FIRSTNAME, LASTNAME, PERSNUMBER in the "source" table, update the value of FIRSTNAMEn, LASTNAMEn, PERSNUMBERn.
This has to be in pure SQL 2000 compatible format.
I hope this is clear. Please look at the uploaded DB schema and sample data files.
Thanks,
Dan
项目ID: #36850
关于项目
授予:
Hello, I am in wisconsin and have been working with MS SQL since ver 4, way back (10+ yrs). I can create a pure SQL script that will do the conversion.
有14名威客正在参与此工作的竞标,均价$127/小时
dear Sir, I think it is the most simple programing that I ever done. Please contact us for detail. If you doen't satisfied I'll give your money back 100 %.
Hello...i.m working with large SQL SERVER database and, daily, make some kind of T-SQL scripts (procedures and functions). I can do it in 1 day for you...