Em Andamento

SQL Stored basic Procedure

I need a SQL Server 2000 stored procedure that can do the following.

Sort a table similar to the following by column SVC_TYPE, BEG, END. Also the stored procedure should update the group column with the correct group number for each change in SVCTYPE. The group number should always start with 1.

<colgroup> <col style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3584" span="5" width="98" /></colgroup>

| ID | SVCTYPE | BEG | END | GROUP |

| 2 | AAA | 120 | 120 | 1 |

| 1 | AAA | 100 | 100 | 1 |

| 5 | BBB | 100 | 100 | 2 |

| 3 | BBB | 105 | 107 | 2 |

| 6 | CCC | 210 | 210 | 3 |

| 4 | CCC | 210 | 210 | 3 |

| 7 | DDD | 155 | 155 | 3 |

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

SQL SErver 2000

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: form 210, ccc group, aaa a, stored, mso, DDD, CCC, update code sql, php sql 2000, sql run package, php sql update, update sql code, 107, SQL stored, php form sql, form update sql, aaa software, basic engineering, sql update, sql 2000, sql update code, sort sql, update sql php, sql number, sort table sql php

Acerca do Empregador:
( 68 comentários ) United States

ID do Projeto: #3027151

Premiar a:

oscommercevw

See private message.

$7 USD em 1 dia
(137 Avaliações)
5.6

13 freelancers are bidding on average $13 for this job

DFlor

See private message.

$17 USD em 1 dia
(25 Comentários)
6.2
ekam

See private message.

$11.05 USD em 1 dia
(111 Comentários)
5.7
mayurshahvw

See private message.

$17 USD em 1 dia
(4 Comentários)
3.1
sanksvw

See private message.

$12.75 USD em 1 dia
(5 Comentários)
2.5
softwarexchange

See private message.

$17 USD em 1 dia
(3 Comentários)
2.2
csharpscripter

See private message.

$12.75 USD em 1 dia
(0 Comentários)
0.0
nelsonandaravw

See private message.

$5.95 USD em 1 dia
(0 Comentários)
0.0
chrisxp

See private message.

$17 USD em 1 dia
(0 Comentários)
0.0
puvakil

See private message.

$17 USD em 1 dia
(0 Comentários)
0.0
iterant

See private message.

$8.5 USD em 1 dia
(0 Comentários)
0.0
neosorin

See private message.

$12.75 USD em 1 dia
(1 Comentário)
0.0
frankjuszli

See private message.

$15.3 USD em 1 dia
(0 Comentários)
1.4