Cancelado

Write small SQL script

Please only bid if you are SQL EXPERT as i have only a short time to complete

I have a small SQL project to write a bit of code to extract some data from a diary system.

What I need to do is use two tables:

Table 1: Holds information on helpdesk calls. From this table I need the script to find all records which are still active.

Table 2: Holds all of the diary updates for the calls. From this table I need to fetch the LAST record associated with the ACTIVE calls in table 1 and give me some information about those records

I have got the basics of the script but it returns duplications so I need someone who can update it or create a new one without these duplications.

Habilidades: Engenharia, Gestão de projetos, Instalação de Script, Shell Script, Arquitetura de software, Teste de Software

Ver mais: write a bit or bit, find someone to write a code, find someone to write, write some sql for a project, sql script , sql project , IT helpdesk, helpdesk it, extract tables, small data table, update code sql, sql create script, extract records, system diary, update sql code, write script extract data, script sql table, project management write, project management records, diary project, helpdesk project, small expert system, expert extract, install sql script, need small script

Acerca do Empregador:
( 84 comentários ) Newcastle, United Kingdom

ID do Projeto: #3039268

23 freelancers estão ofertando em média $4 para este trabalho

sinharavi

See private message.

$4.25 USD in 2 dias
(69 Comentários)
5.8
CGeorges

See private message.

$4.25 USD in 2 dias
(17 Comentários)
4.6
vw1717421vw

See private message.

$4.25 USD in 2 dias
(66 Comentários)
4.7
yubor

See private message.

$4.25 USD in 2 dias
(25 Comentários)
4.3
wesolvevw

See private message.

$4.25 USD in 2 dias
(33 Comentários)
4.0
sergeylisovsky

See private message.

$4.25 USD in 2 dias
(6 Comentários)
4.0
AgileDeveloper1

See private message.

$4.25 USD in 2 dias
(6 Comentários)
3.3
w3worker

See private message.

$4.25 USD in 2 dias
(12 Comentários)
3.1
jackcode

See private message.

$4.25 USD in 2 dias
(4 Comentários)
2.6
javaperloracle

See private message.

$4.25 USD in 2 dias
(7 Comentários)
2.5
shouket

See private message.

$4.25 USD in 2 dias
(7 Comentários)
2.5
richardwagner

See private message.

$4.17 USD in 2 dias
(1 Comentário)
2.3
Maneesh6

See private message.

$4.25 USD in 2 dias
(1 Comentário)
1.4
derley

See private message.

$4.25 USD in 2 dias
(3 Comentários)
1.3
xapavovw

See private message.

$4.25 USD in 2 dias
(1 Comentário)
1.3
erickhvw

See private message.

$4.25 USD in 2 dias
(3 Comentários)
0.1
patelrajan2000

See private message.

$4.25 USD in 2 dias
(2 Comentários)
0.0
webdevelopers110

See private message.

$3.4 USD in 2 dias
(3 Comentários)
0.0
AweSoft

See private message.

$3.4 USD in 2 dias
(0 Comentários)
0.0
syedasadmanzoor

See private message.

$4.25 USD in 2 dias
(0 Comentários)
0.0