Closed

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

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)

Skills: C# Programming, Database Administration, Microsoft SQL Server, MySQL, SQL

See more: char vs varchar performance sql server, sql convert varchar to int, sql convert text to number, sql convert string to decimal, sql convert varchar to numeric, sql convert nvarchar to int, sql cast example, nvarchar vs varchar performance, convert business works data quickbooks, convert business card database, convert business card contacts forum, convert multiple column rows excel, convert business works quickbooks, convert business lan wan, convert business card contact

About the Employer:
( 9 reviews ) Amman, Jordan

Project ID: #16068471

29 freelancers are bidding on average $25 for this job

mahmoudgamal008

I have more than 5 years of professional and practical experience in SQL, SQL Server and database development. Relevant Skills and Experience I have more than 1800 answers in Stackoverflow(Q&A Site) http://stackoverf More

$30 USD in 1 day
(49 Reviews)
5.9
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 More

$25 USD in 1 day
(44 Reviews)
5.2
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 in 1 day
(46 Reviews)
5.3
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 More

$14 USD in 0 days
(19 Reviews)
3.9
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 More

$25 USD in 1 day
(5 Reviews)
3.6
PATechnology

A proposal has not yet been provided

$20 USD in 2 days
(12 Reviews)
3.3
$25 USD in 1 day
(5 Reviews)
2.8
$25 USD in 1 day
(1 Review)
3.0
$25 USD in 1 day
(5 Reviews)
2.6
codingCafe

hi, This is Rahul , i am full stack freelance web developer, i will create extra column in your table like slug which replace the id in the url, i'll start project right away. Relevant Skills and Experience I have dev More

$15 USD in 1 day
(9 Reviews)
2.6
periyannas

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

$25 USD in 0 days
(8 Reviews)
2.7
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 - Miles More

$35 USD in 1 day
(3 Reviews)
1.7
$20 USD in 1 day
(1 Review)
2.0
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 a More

$25 USD in 1 day
(1 Review)
1.6
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 Ora More

$25 USD in 0 days
(1 Review)
1.2
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 More

$25 USD in 1 day
(1 Review)
0.8
AhmedRaef

I read through the project details extremely carefully and I 'm absolutely sure that I can do the project very well I'm expert in .Net and I never compromise in quality. Looking forward from your end Relevant Skills a More

$25 USD in 1 day
(0 Reviews)
0.0
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 in 0 days
(0 Reviews)
0.0
OleksandrBolilyi

I am a software developer with 3 years of experience with C# language and .NET Framework and T-SQL language. Relevant Skills and Experience I have 3 years of C# and .NET Framework experience, and T-SQL language. Prop More

$30 USD in 5 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0