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.\
62 freelancers are bidding on average $42 for this job
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
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.
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
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.