Devam Ediyor

Convert SQL Table to new format.

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

Beceriler: Veri İşleme

Daha fazlasını görün: will holding, source format, schema update, job values, has attached, table format sql, transact sql convert est, convert sql perl, different table format, convert sql tables, daily report convert sql, sql table format, convert sql table, table, sql data, sql c, schema, holding, data source sql, data format, data convert, update sql file, sql different, schema sql, update insert sql

İşveren Hakkında:
( 1 değerlendirme ) Spring Valley, United States

Proje NO: #36850

Seçilen:

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.

1 gün içinde 100$ USD
(1 Değerlendirme)
2.0

15 freelancer bu iş için ortalamada 126$ teklif veriyor

momleetech

We can do it.

in 5 gün içinde100$ USD
(6 Değerlendirme)
4.3
cstl

Our bid is 199 $ for the whole project. Bid includes development , deployment and testing. we offer 30 days free support. We are ready start and send daily reports. we communicate through mail,messenger,phone and Daha fazlası

in 5 gün içinde199$ USD
(2 Değerlendirme)
3.0
Snum

See PMB ...

1 gün içinde 100$ USD
(1 Değerlendirme)
2.0
websoftinfo

Our bid is for really very high quality work for your Convert SQL Table to new format that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our bid inclu Daha fazlası

in 10 gün içinde300$ USD
(1 Değerlendirme)
1.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 %.

1 gün içinde 100$ USD
(0 Değerlendirme)
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 Daha fazlası

in 2 gün içinde105$ USD
(0 Değerlendirme)
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 Daha fazlası

1 gün içinde 100$ USD
(0 Değerlendirme)
0.0
Shahyar7

I'm working and programming with MS SQL for more than 5 years. I can do it for you.

in 4 gün içinde120$ USD
(0 Değerlendirme)
0.0
knowledgehub

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

in 5 gün içinde100$ USD
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde120$ USD
(0 Değerlendirme)
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...

1 gün içinde 101$ USD
(0 Değerlendirme)
0.0
FoxART

Hello. Ready to do this project!

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0
datasolinfo

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

1 gün içinde 150$ USD
(0 Değerlendirme)
0.0
LILkillaBEE

I have solution for you.

1 gün içinde 100$ USD
(0 Değerlendirme)
0.0