SQL Server - Sql to Update/replace part of string

$30-250 USD

Terminado

Publicado

hace más de 8 años

$30-250 USD

Pagado a la entrega

Hello I need a SQ statement to replace some characters in a string. I have a table with 2 fields: original value replaced by ¾ ó Ý í etc You will read a field in a given table (variable) and search for "original value" (one or more characters in the field) and if you found it, then update the field with the value in "replaced by". For example, if you found the value: Example 1 - "Le¾n", then you will update with the value "León" Example 2 - "PurÝsima del Rinc¾n" the you will update with the value "Purísima del Rincón" thanks

Microsoft SQL Server

SQL

ID del proyecto: 8626221

Información sobre el proyecto

13 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@mdkass

Hi, again This can be done usibg a stored procedure, it can't be done with a single sql statement..

$34 USD en 1 día

5,0

(14 comentarios)

4,7

13 freelancers están ofertando un promedio de $133 USD por este trabajo

@karunakartiwari

A proposal has not yet been provided

$222 USD en 3 días

4,8

(31 comentarios)

5,6

@marasinghe82

Dear Sir, Hope you remember me . I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and six years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh

$55 USD en 1 día

5,0

(68 comentarios)

5,7

@YevgenyB

Hi! I can provide a solution for that. I will provide 2 stored procedure (one for single string other for table) which will return corrected string or update a table, Please contact if interested. regards, Yevgeny

$77 USD en 1 día

5,0

(3 comentarios)

3,4

@bongbong88

hi sir Let me help you I have good experience for SQL server management Could you pleaes provide me you sql script? And Could you please provide me your database collation ? Thanks/

$147 USD en 1 día

5,0

(2 comentarios)

2,1

@abdowong

Hello! I am an expert using MSSQL, so I can accomplish what you need If you need this before 2 days (as I proposed), let me know and I can move my schedule to get it for you sooner. Do you need this in a stored procedure, maybe called from a job? or will be called on demand by code? Thanks!

$88 USD en 1 día