SQL - Convert the Business Name Column (varchar) to (INT) to be used in the URL. (Read description)

$10-30 USD

Avslutat

Publicerad

över sex år sedan

$10-30 USD

Betalning vid leverans

I am working on MVC website connected to SQL database. I have a page for every single row. Right now I'm using the row ID for the page url, because it's the only (INT) column I have. What I need is to use the business name instead of the row ID. But the business name column has many duplicates and special characters. For the duplicates I need to add a number next to the name (Sequently). For the special characters (NON-ASCII) I need to replace them with ASCII characters. For the spaces I need to replace them with (-). And lastly I need to convert the business name column (varchar) to (INT)

C# Programming

Database Administration

Microsoft SQL Server

MySQL

SQL

Project ID: 16068471

Om projektet

26 anbud

Distansprojekt

Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

26 frilansar lägger i genomsnitt anbud på $25 USD för detta uppdrag

@Agiletechstudio

Hi, i read your initial requirements i tried to understand and want discuss some points points relating your project. Relevant Skills and Experience I have relevant experience in .net development of 5 years. Proposed Milestones $25 USD - whole project

$25 USD Om 1 dag

5,0

(95 omdömen)

7,5

@FerriSoft1

Would you send me your SQL DB for me to see it, don't need to award me. I got lost at the end when you said the formatted name (no duplictates, no spaces, no specials ascii) would be converto to INT? Relevant Skills and Experience +15 years of SQL experience Proposed Milestones $25 USD - Project

$25 USD Om 1 dag

5,0

(45 omdömen)

7,0

@azmatakhtar

please contact me after looking my profile. i have a question regarding changing type from varchar to int Relevant Skills and Experience MVC Proposed Milestones $30 USD - initial

$30 USD Om 1 dag

5,0

(75 omdömen)

6,1

@softcarve

Hi, I would like to change the business name instead of the row ID in your code please get in touch to discuss more. Regards, Manish Relevant Skills and Experience I have good proficiency in sql. Please go through my profile. Proposed Milestones $25 USD - completion

$25 USD Om 1 dag

4,9

(103 omdömen)

5,9

@periyannas

Sure. let me help you. Relevant Skills and Experience coder Proposed Milestones $25 USD - Task

$25 USD Om 0 dag

5,0

(15 omdömen)

4,7

@PATechnology

A proposal has not yet been provided

$20 USD Om 2 dagar

4,9

(35 omdömen)

4,8

@vw7590795vw

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html Relevant Skills and Experience I have 8 years and 2 month experience in SQL Proposed Milestones $14 USD - SQL - Convert Please let me know more details and when we will start. Sky pe: jikenjd

$14 USD Om 0 dag

5,0

(25 omdömen)

4,2

@sreenivas2903

HI , I would like to complete this task in 1 day and let you know if I have any further . I am bidding this as low as possible to get this bid and prove myself . Hope I would give you assurance for further tasks

$15 USD Om 0 dag

4,8

(20 omdömen)

4,5

@zallim

I am oracle certified and much experience in c#. I can solve this problem within 1 day. give me this task. Relevant Skills and Experience I have 4 years experience as a programmer. Proposed Milestones $35 USD - Milestones will be planned in inbox.

$35 USD Om 1 dag

4,9

(11 omdömen)

3,8

@mohsinuetion

I am an experienced Oracle/SQL Server/MySql/PostgreSQL DBA/Developer.. I solely responsible for Administering, Managing, Designing, developing Planning databases. Relevant Skills and Experience I am an experienced Oracle/SQL Server/MySql/PostgreSQL DBA/Developer.. I solely responsible for Administering, Managing, Designing, developing Planning databases. Proposed Milestones $25 USD - all work I am an experienced Oracle/SQL Server/MySql/PostgreSQL DBA/Developer.. I solely responsible for Administering, Managing, Designing, developing Planning databases.

$25 USD Om 0 dag

4,9

(4 omdömen)

2,9

@samerjoseph

sir . I've been through many issue just like your request to edit in SQL DB to replace or add or any thing else , i can even develop a C# application to do this , lets talks fro details Relevant Skills and Experience I'm a professional .Net developer with a wide experience in C# , SQL Server and many other terms and technologies Proposed Milestones $10 USD - on start $15 USD - at the end

$25 USD Om 1 dag

5,0

(1 omdöme)

0,8

@ibtasam2017

A proposal has not yet been provided

$25 USD Om 2 dagar

0,0

(0 omdömen)

0,0

@FatemaNoor

Dear sir Hello I am very much Interested in your Project, Can we discuss it further please? I am expert in Data Entry. Best Regards Fatema Relevant Skills and Experience Data Entry, SQL Proposed Milestones $25 USD - project

$25 USD Om 1 dag

0,0

(0 omdömen)

0,0

@sakpalVinay

As I have placed $20 bid for 2 days, I will understand the problem statement and work on the changes required. Relevant Skills and Experience I am too working on the MVC/SQL Server project and that is added advantage for me. Proposed Milestones $5 USD - Change datatype of the field $5 USD - Url mapping to int $5 USD - Replacing Non-ASCII character with ASCII character $5 USD - Testing Additional Services Offered $1 USD - Will help you to resolve the issue in future

$20 USD Om 2 dagar

0,0

(0 omdömen)

0,0

@mirodrig50

modify sql Relevant Skills and Experience I have a lot time for modify sql. Proposed Milestones $25 USD - Modify sql

$25 USD Om 10 dagar

0,0

(0 omdömen)

0,0

@santynet

I"m assuming the reason you want to change from using the ID to the Company name is for SEO purposes? There's a better way without loosing the databse integrity of the ID. Relevant Skills and Experience I've worked on Business Listing sites in the past. I have found that a good solution is to keep the ID in the URL, but add the company name as well. This way the company name will help with SEO. Proposed Milestones $45 USD - Add the company name to the URL along with the ID

$45 USD Om 3 dagar