Lukket

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)

Evner: C# Programmering, Database Administration, Microsoft SQL Server, MySQL, SQL

Se mere: convert business works data quickbooks, convert business card database, convert business card contacts forum, 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, mysql, software development, sql, software architecture, .net, microsoft sql server, database development, database programming, convert multiple column rows excel

Om arbejdsgiveren:
( 9 bedømmelser ) Amman, Jordan

Projekt ID: #16068471

29 freelancere byder i gennemsnit $25 på dette 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 Flere

$30 USD på 1 dag
(49 bedømmelser)
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 Flere

$25 USD på 1 dag
(44 bedømmelser)
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 på 1 dag
(46 bedømmelser)
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 Flere

$14 USD in 0 dage
(19 bedømmelser)
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 Flere

$25 USD på 1 dag
(5 bedømmelser)
3.6
PATechnology

A proposal has not yet been provided

$20 USD in 2 dage
(12 bedømmelser)
3.3
$25 USD på 1 dag
(5 bedømmelser)
2.8
$25 USD på 1 dag
(1 bedømmelse)
3.0
$25 USD på 1 dag
(5 bedømmelser)
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 Flere

$15 USD på 1 dag
(9 bedømmelser)
2.6
periyannas

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

$25 USD in 0 dage
(8 bedømmelser)
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 Flere

$35 USD på 1 dag
(3 bedømmelser)
1.7
$20 USD på 1 dag
(1 bedømmelse)
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 Flere

$25 USD på 1 dag
(1 bedømmelse)
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 Flere

$25 USD in 0 dage
(1 bedømmelse)
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 Flere

$25 USD på 1 dag
(1 bedømmelse)
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 Flere

$25 USD på 1 dag
(0 bedømmelser)
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 dage
(0 bedømmelser)
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 Flere

$30 USD in 5 dage
(0 bedømmelser)
0.0
$25 USD på 1 dag
(0 bedømmelser)
0.0