Convert nvarchar type fields to new date type field.

$10-30 USD

In Progress

Posted

over 10 years ago

$10-30 USD

Paid on delivery

Need help to convert 2 fields (nvarchar datatype) to a date field ( date datatype ) in MS Sql server 2008r2. For example: field1 ='22nd' , field2 = 'May, 2013'; both these fields are in nvarchar ( 50). Prefer a store procedure or a SQL update to insert a date value into a date field3 according to those nvarchar field1&field2. The result should be '2013-05-22' in the field3 ( date datatype ).

.NET

ASP

C# Programming

Database Administration

SQL

Project ID: 5096494

About the project

11 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

11 freelancers are bidding on average $25 USD for this job

@LearningNew

More then 7 years of working experience in Telerik Open Access ORM, Entity FrameWork using Code First, Database First Approaches, ASP.NET, Window Service, Web Service, MVC 3.0, MVC 4.0, C#, VB.NET, SQL Server, Access, JQUERY, Fluent/UnObtrusive and JQuery Validation. I have good experience in trouble shooting Front End issues and Performance tuning of Sql Server Database

$50 USD in 0 day

4.9

(75 reviews)

6.8

@liemvo

I think it's easy. I can do it right now. It just spend a few of hours for me. Let me do it. I suggest that I will write a store procedure or function in sql. All you need to do is call this store procedure with input nvarchar type and output the date type. Many thanks, Liem

$20 USD in 3 days

5.0

(34 reviews)

6.1

@ielkfarna

Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,

$24 USD in 0 day

4.5

(44 reviews)

5.9

@khoaht

Hi, I will make the database script to read data from two fields and insert into the new field like you required. Please contact me for your good results. Thank you, Khoa Ho.

$15 USD in 1 day

4.4

(10 reviews)

5.0

@RKYSP

Hi, I can do this convertion and insert the data in the new field as i have more than 10yrs of experience in SQL Server database.

$20 USD in 3 days

4.8

(19 reviews)

4.3

@binarygeotech

I'm an experienced web and windows application developer with many years of experience. I can do do your project. Please contact me. Thanks G. O. Davis

$25 USD in 0 day

4.9

(5 reviews)

3.8

@MaxTech3

i can do.....this.....provide more details....or files...,...........................................................................

$25 USD in 2 days

5.0

(1 review)

1.3

@MinThet

A proposal has not yet been provided

$28 USD in 5 days

0.0

(0 reviews)

0.0

@s3rg1u

i can do it for you, i have experience working with MS SQL SERVERS, and sql language and i know to make a stored procedure so your task could be accomplished verry fast at a small price

$25 USD in 3 days

0.0

(2 reviews)

0.0

@quooclee

A proposal has not yet been provided

$15 USD in 1 day

0.0

(0 reviews)

0.0

@AmjadHussainpk

Dear Sir, This is very small task and i can do for you with in 24 hours. I have already awarded one project but due to some personal problem we can not communicate for 4 hours so client cancel the project so i want to show freelancer i am not foolish. Please you can give me opportunity to show my self Thanks

$25 USD in 1 day