Closed

SQL script to modify data

I have a MSSQL 2008 R2 server that has a table I need someone to write a SQL query that will split an address field containing "ST. Peters MO 63132" into "St. Peters", and "MO", and "63132". Zip is constantly last 5 chars. Starting at the end of the field value splitting by space. Convert it to City, State, Zip fields.

In same Query. Convert Thursday 05/23/2013 to MMDDYYYY

In same Query, select a employee code via a JOIN on an employee table by Emp_Name = Emp_Name

This should only take the right person about 1 hour.\

Skills: Database Administration, SQL

See more: sql script , Sql Database administration, database employee, convert sql database, SQL Server administration, query mssql, convert sql code, data scramble script sql, city state zip database, script sql table, convert code sql server 2008, modify query, sql server 2008 database administration, sql employee database code, sql code convert, sql select script, select state zip, zip code sql database, select state city script, sql employee database, sql query field, employee database sql, convert sql query sql query, convert sql query sql, zip code database sql

About the Employer:
( 31 reviews ) United States

Project ID: #5016956

62 freelancers are bidding on average $42 for this job

rinsadsl

Dear customer Can you remember me? I worked on this project. [url removed, login to view] I can do this project immediately for you. Looking forward to hear from you. Than More

$33 USD in 0 days
(31 Reviews)
5.2
thanhlongfree

Hi. I can do this for you very quickly. I'm 8 years experienced in SQL. Please give me a chance. Thanks very much

$39 USD in 3 days
(17 Reviews)
5.1
feninsoftech

Hi, I have 8.5 years experience in SQL Server. I have expertise in writing complex queries with proper joins and index selection. In past, i involved in balancing between concurrency and locking and lock escalation. More

$55 USD in 3 days
(10 Reviews)
4.8
sikandermandal

Dear Sir, This is Sikander. I am read y for it and will send you script very soon. Please allow me to work on this. I am having 12+ years of experience in MSSQL. Please send me details of database so that I can look More

$35 USD in 1 day
(9 Reviews)
4.6
manhpham

Hi there. I am senior developer from Vietnam. I have been working on this site for 2 years. I am interested in your [url removed, login to view] let's me help you.

$66 USD in 1 day
(12 Reviews)
4.3
elboukharimu

Hi, I'm very interested helping you creating your SQL script, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some sampl More

$49 USD in 0 days
(11 Reviews)
4.3
Prateekagra

HI i have a very good experience in the SQL and it will be done in 1/2 hr .tell me when we can discuss this and complete the same

$55 USD in 1 day
(3 Reviews)
3.7
nutanbhosale

Hi, I can do this for you within few hours after the project is awarded. The requirement a query to: 1. Split Address state zip from a text field 2. Pick date from text in mmddyyyy 3. Lookup the employee code More

$39 USD in 1 day
(4 Reviews)
3.6
yubor

Hi. I am expert in SQL Server. Certified as MCSE: Data Platform. Assure you of my 100%quality work. Yuri

$35 USD in 1 day
(15 Reviews)
3.6
zafoxyfox

Sure I can assist. getting Zip won't be a problem. Working back I'll probably do a lookup against list of USA States and the rest is the first (City) field - that is unless it's Zip (Last 5), next two chars workin More

$35 USD in 1 day
(3 Reviews)
3.4
gobublik

Hello I can develop such sql code for you, I'm very good with it. Should it be stored procedure or just a sql select query ? Please provide create table statement as well Thank you, Vitali

$30 USD in 2 days
(2 Reviews)
3.2
ahetel

Hi, Indeed 1 hour is more than enough for this. But, all 3 requests cannot be done in a single query. First one for example can be done in a couple of steps, something like this: - delete last 5 characters from a More

$55 USD in 0 days
(7 Reviews)
2.9
hardikshah83

Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Micr More

$34 USD in 1 day
(3 Reviews)
2.5
PerfectInfo

I am expert in this and have done similar work in past. Please see my review. Ready to start immediatly. I'll deleiver it withn an hour. Hire me. Thanks

$30 USD in 3 days
(1 Review)
1.9
jwbart10

Lets do this, right now , I am in front of my computer. Senior SQL Server Developer, 5 1/2 years experience. I eat update statements for breakfast, it is 10:40 am and I am hungry.

$30 USD in 1 day
(1 Review)
1.8
evadevlopers

Hi There, ready to start now. i have 5+ experience in PHP as well as Database Administration, SQL etc, let's more discuss and start your work right now. Too look forward your replay Thanks

$74 USD in 1 day
(1 Review)
1.7
luki555

Hi, I'm experienced T-SQL developer. This is easy task and I already have it done. Just send me the database structure for this query (table names, columns and types). With regards Lukas Harvanek.

$30 USD in 1 day
(2 Reviews)
1.3
AliSafder

I can get it done right now. Please let me start on this task. I am waiting for your response and let me know when we can start

$30 USD in 0 days
(2 Reviews)
1.2
Jchaudhari14

Hi, Can be done nicely within your expected time & quality. I have 8.5+ years of experience in well known RBDMS technologies specially in ms sql, oracle, my sql. Let me know if you need any information for the s More

$35 USD in 1 day
(3 Reviews)
1.1
danangvw

I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration a More

$30 USD in 1 day
(1 Review)
0.8