Convert SQL Table to new format.

进行中 已发布的 Dec 20, 2005 货到付款
进行中 货到付款

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

关于项目

14个方案 远程项目 活跃的Dec 21, 2005

授予:

pmbtech

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.

$100 USD 在1天内
(1条评论)
2.0

有14名威客正在参与此工作的竞标,均价$127/小时

momleetech

We can do it.

$100 USD 在5天内
(6条评论)
4.3
Snum

See PMB ...

$100USD 在1天里
(1条评论)
2.0
whizzkid

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 %.

$100USD 在1天里
(0条评论)
0.0
NETallica

Sir, I'm a qualified DBA (a Microsoft Certified Professional for SQL Server 2000) having 7-year experience in this field. I can do your project on timely fashion with no extra cost and problems for you. best regard 更多

$105 USD 在2天内
(0条评论)
0.0
lsys

We are very experienced in working with MS SQL. We can do your job. I think that there are certain details in your request that need to be refined before starting it. If you pick our bid we may discuss this prior to st 更多

$100USD 在1天里
(0条评论)
0.0
knowledgehub

Hello, Please check PMB. Kind Regards KHS (KnowledgeHub)

$100 USD 在5天内
(0条评论)
0.0
neeraj523

Hello Conceptually.. this job can be completed in above mentioned estomate. But i feel there are few things which need discussion over the data structure of the resulting tables.. I feel it can be structured in a bett 更多

$120 USD 在3天内
(0条评论)
0.0
simicik

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...

$101USD 在1天里
(0条评论)
0.0
FoxART

Hello. Ready to do this project!

$100 USD 在5天内
(0条评论)
0.0
datasolinfo

we have the experts for sqlserver, and v can accomplish this task in just one day.

$150USD 在1天里
(0条评论)
0.0
LILkillaBEE

I have solution for you.

$100USD 在1天里
(0条评论)
0.0