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

$10-30 USD

Đã đóng

Đã đăng vào

hơn 6 năm trước

$10-30 USD

Thanh toán khi bàn giao

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

Mã dự án: 16068471

Về dự án

26 đề xuất

Dự án từ xa

Hoạt động 6 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

26 freelancer chào giá trung bình $25 USD cho công việc này

@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 trong 1 ngày

5,0

(95 nhận xét)

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 trong 1 ngày

5,0

(45 nhận xét)

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 trong 1 ngày

5,0

(75 nhận xét)

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 trong 1 ngày

4,9

(103 nhận xét)

5,9

@periyannas

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

$25 USD trong 0 ngày

5,0

(15 nhận xét)

4,7

@PATechnology

A proposal has not yet been provided

$20 USD trong 2 ngày

4,9

(35 nhận xét)

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 trong 0 ngày

5,0

(25 nhận xét)

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 trong 0 ngày

4,8

(20 nhận xét)

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 trong 1 ngày

4,9

(11 nhận xét)

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 trong 0 ngày

4,9

(4 nhận xét)

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 trong 1 ngày

5,0

(1 nhận xét)

0,8

@ibtasam2017

A proposal has not yet been provided

$25 USD trong 2 ngày

0,0

(0 nhận xét)

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 trong 1 ngày

0,0

(0 nhận xét)

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 trong 2 ngày

0,0

(0 nhận xét)

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 trong 10 ngày

0,0

(0 nhận xét)

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 trong 3 ngày