Đã hoàn thành

165314 sql script

I need a sql script/procedure to split a text string in a db field in 3 fields and update a separate table, see sample db for details,

The DB is on MS SQL 2005

Basically I need to split this data from a single field

[url removed, login to view] [Microsoft Corporation] [url removed, login to view]

into 3 fields

[url removed, login to view]; Microsoft Corporation; 2050727832 and update another table

then I need to run a comparison against another reference table to find the software that is below a certain version

I'll provide real data to do real testing

Kĩ năng: Bất kì công việc gì, SQL

Xem nhiều hơn: sql software, sql script , sql microsoft, sql update text, sql update field text, update text sql, sql update text field, update field sql field field, sql update text text, text sql, script sql table, script find version, comparison table, testing sql, split run, sql update, script sql update, split testing software, sql update script, procedure text, sql update fields, sql field sql 2005 table, sql table update data, sql update data fields, update exe

Về Bên Thuê:
( 1 Nhận xét )

ID dự án: #1911505

Được trao cho:


I can do it immediately, I already have the split code! please see PMB

$10 USD trong 0 ngày
(0 Đánh Giá)