I gang

SQL Sorting Function w/ update

I like to build a customized SQL Sorting function that is able to writeback an integer containing the ordering sequence back to the table.

I will give you an example:

Example_table:

ID NM SORT_KEY

100 Peter Null

101 John Null

102 Amy Null

103 Albert Null

104 Charley Null

Then the SQL query shall be applied and the results shall look like:

ID NM SORT_KEY

100 Peter 5

101 John 4

102 Amy 0

103 Albert 1

104 Charley 2

The query shall be called via a function with 2 parameters as in: sort_n_stor_key(table_nm, sort_key, asc/dec)

Færdigheder: SQL

Se mere: SQL Query, null, john w, function, build sql, amy, albert, 101, 102 103, sql update, sql sql, update 100, 102, sql query sql query, table ordering, update query, update javascript function, sql back, search function terms sql website, rails update multiple records single sql, php function export sql pdf, check update record exist database sql, back sql, user defined function irr sql, update sql

Om arbejdsgiveren:
( 111 bedømmelser ) Boston, United States

Projekt-ID: #925747

Tildelt til:

djain01

Hi, Let do it.. SQL Expert.. Pls Check PMB.. Thanks

$30 USD in 0 dage
(15 bedømmelser)
4.6

26 freelancere byder i gennemsnit $38 for dette job

eperfections

SQL Expert here. Will be done in short time. Please check INBOX. Thanks ePerfections

$30 USD in 0 dage
(70 bedømmelser)
5.9
servicebenq

Hi See you pm please. Regards

$30 USD in 0 dage
(10 bedømmelser)
4.2
RedhopIT

Hi,Please check pm

$30 USD in 0 dage
(3 bedømmelser)
3.4
acesolution

lets do it in half an hour ....

$30 USD in 0 dage
(2 bedømmelser)
3.3
phobosq

Hi, I'm an experienced SQL DBA/developer, would be happy to work for you. Please check your PMB.

$30 USD på 1 dag
(1 bedømmelse)
2.0
freelancerbuzzo

Ready to start right now.

$30 USD på 1 dag
(2 bedømmelser)
2.0
win4t4

Hi, I can do this for you. But can you tell me what database server do you use ? My guess is SQL Server 2005. Is that correct ?

$30 USD på 1 dag
(1 bedømmelse)
1.8
ppap

I am able to provide you with the necessary code, but it will be stored procedure, not table-valued function. You can not execute dynamic queries within a function. Probably, this can be accomplished by CLR, but I don' Mere

$30 USD på 1 dag
(0 bedømmelser)
0.0
RajeshKAggarwal

I can perform this job in quick time

$30 USD in 0 dage
(0 bedømmelser)
0.0
satyapalgarhwal

ready to work with u

$30 USD in 0 dage
(0 bedømmelser)
0.0
stevlada

I can do it.

$30 USD på 1 dag
(0 bedømmelser)
0.0
mosulyca

Hi! What is the DB you useit? Thank's.

$30 USD på 1 dag
(0 bedømmelser)
0.0
Medhananda

I'm Medhananda my I can do this job because I'll working with SQL database handling and server. I have 3 years work experience with sql server

$230 USD in 30 dage
(0 bedømmelser)
0.0
gaurav15011987

Hi, I have 15 years of experience in Oracle PL/SQL, Siebel CRM, Java, C++ and various technologies. I have worked for various MNCs like Accenture, IBM, Capgemini in the past. I will deliver this project in half day fl Mere

$30 USD på 1 dag
(0 bedømmelser)
0.0
Takal

Hi, I can do [url removed, login to view]

$30 USD på 1 dag
(0 bedømmelser)
0.0
kumar241915

I can create a function for this project with in 40Mins and give it to you.

$30 USD på 1 dag
(0 bedømmelser)
0.0
nano0511

I'm DBA in SQL Server and this script is easy to make

$30 USD in 0 dage
(0 bedømmelser)
0.0
keustps

i can tell you without payment. It's very simple...

$30 USD in 0 dage
(0 bedømmelser)
0.0
straight14

Hello Sir, please check PM.

$30 USD in 0 dage
(0 bedømmelser)
0.0
nanookon

Hello, I could quickly deliver you the wanted function/

$30 USD på 1 dag
(0 bedømmelser)
0.0