Cancelado

SQL Stored Procedure to create xml

Hi all,

I am looking for some help in generating an xml file by joining 2 tables in sql 2005 db.

Table 1 (companyprofile) holds company data which has the following columns:

GV (int), Name (varchar), value (varchar), and Note(varchar)

Table 2 holds the company's financial data for each year and has the following columns:

GV (int), Year (smalldatetime), Name (varchar), value (varchar), and Note(varchar).

I need to combine the 2 tables and generate an xml in the format.

I believe we have to use FOR XML EXPLICIT or PATH with proper table joining. I need some help with this as I am totally new to sql.

Thanks

## Deliverables

Required XML Format:

<C>

<!-- company demographic information-->

<A>

<AN></AN>

<V></V>

<F />

</A>

<!-- company yearly financial data-->

<Y Y="1996">

<A>

<AN></AN>

<V></V>

<F />

</A>

</Y>

<!-- company yearly financial data-->

<Y Y="2002">

<A>

<AN></AN>

<V></V>

<F />

</A>

</Y>

<!-- company yearly financial data-->

<Y Y="1990">

<A>

<AN></AN>

<V></V>

<F />

</A>

</Y>

and so on for about 20 years...

</C>

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

Ver mais: need sql help, int v, stored, php xml file use php, sql required, combine create, proper xml format, php procedure create file, stored procedure create sql, SQL stored, php data stored xml, php generate xml, ratchelt, proper format xml file, company xml, xml sql 2005, procedure generate xml file, required xml, php file combine, generate file xml php, xml data table, create xml, sql tables xml, sql php xml, yearly sql

Acerca do Empregador:
( 14 comentários ) louisville, United States

ID do Projeto: #3030848

20 freelancers estão ofertando em média $63 para este trabalho

fastudiovw

See private message.

$21.25 USD em 1 dia
(656 Comentários)
7.4
hwanghendra

See private message.

$19.55 USD em 1 dia
(401 Comentários)
6.8
vnb400sl

See private message.

$102 USD em 1 dia
(119 Comentários)
5.9
NeoNoXtraOrdnry

See private message.

$25.5 USD em 1 dia
(87 Comentários)
5.8
seventhsensesl

See private message.

$8.5 USD em 1 dia
(66 Comentários)
4.9
jrsansom

See private message.

$24.65 USD em 1 dia
(23 Comentários)
4.5
lbenzaquin

See private message.

$17 USD em 1 dia
(6 Comentários)
3.4
kavitamkumar

See private message.

$34 USD em 1 dia
(5 Comentários)
3.2
erickeeney

See private message.

$21.25 USD em 1 dia
(8 Comentários)
3.0
bello81

See private message.

$21.25 USD em 1 dia
(2 Comentários)
2.9
engineeringforce

See private message.

$25.5 USD em 1 dia
(6 Comentários)
2.8
ftsolutionsvw

See private message.

$42.5 USD em 1 dia
(2 Comentários)
2.5
rexwel

See private message.

$29.75 USD em 1 dia
(3 Comentários)
1.7
amitsharmabhind

See private message.

$85 USD em 1 dia
(0 Comentários)
0.0
khushbubajaj

See private message.

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

See private message.

$170 USD em 1 dia
(0 Comentários)
0.0
satishgetspaid

See private message.

$55.25 USD em 1 dia
(0 Comentários)
0.0
speartechso

See private message.

$46.75 USD em 1 dia
(0 Comentários)
0.0
nanonesys

See private message.

$425 USD em 1 dia
(2 Comentários)
0.6
hungpv77

See private message.

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