Find Jobs
Hire Freelancers

Write some MS SQL XML Queries

$10-30 USD

Terminado
Publicado hace casi 7 años

$10-30 USD

Pagado a la entrega
I have a MS SQL 2016 Database that I store each row of the attached file in separate records. So each XML row is a separate record with all of the xml data for that row. What I want is some XML query help to write 4 where statement queries. The attached file has all of the combinations of the WHERE Clause that I need. Most are pretty straight forward. The table in the database is called [ADMIN_Grant_Exporter_Files_XML] and the field is XMLData. All I want is some sample code that I can test and run
ID del proyecto: 14306517

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi. As I understand, you have created the table ADMIN_Grant_Exporter_Files_XML with 74 rows, one for each <row> element in RePORTER_PRJ_X_FY2017_007.xml. Each row contains a single xml field called XMLData. You would like T-SQL procedures for queries listed below. I can provide these procedures. 1. Search for all records by ORG_DUNS number, and show APPLICATION_ID and matched ORG_DUNS. 2. Search for all records by ORG_DUNS number and absolute TERM, and show APPLICATION_ID, matched ORG_DUNS, PI/PI_NAME, PI/PID_ID, and matched TERM. 3. Search for all records by ORG_DUNS number and portion of TERM, and show APPLICATION_ID, matched ORG_DUNS, PI/PI_NAME, PI/PI_ID, and matched TERM. 4. Search for all records by ORG_DUNS number and part of PI name, and show APPLICATION_ID, matched ORG_DUNS, and the PI_NAME and PI_ID of the matched PI. Q. What should happen when a row contains multiple PI's? a. show first PI name and id. b. show first two PIs name and id. c. create separate rows for each PI. Q. What should happen when a row contains multiple matching terms? a. show first matching term. b. show first two matching terms. c. create separate rows for each matching term. My opening bid assumes the simplest case, (a), in both questions. Have I understood correctly?
$25 USD en 1 día
5,0 (10 comentarios)
4,7
4,7
13 freelancers están ofertando un promedio de $41 USD por este trabajo
Avatar del usuario
we have expertise in SQL,MySQL,php, DBA,Access,Xml,Data processing. Client satisfaction is our main motto for long term relationship.
$40 USD en 1 día
4,9 (17 comentarios)
4,9
4,9
Avatar del usuario
Hello, I'm interested to work on this. Looking forward to your message to start the job. Thanks, Sheik
$35 USD en 1 día
4,9 (11 comentarios)
4,1
4,1
Avatar del usuario
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 7.5 years experience in SQL and 4.8 years experience in SSRS, SSIS. Please let me know more details and when we will start. Sky pe: jikenjd
$22 USD en 0 día
5,0 (19 comentarios)
3,9
3,9
Avatar del usuario
A proposal has not yet been provided
$55 USD en 1 día
4,6 (29 comentarios)
4,4
4,4
Avatar del usuario
A proposal has not yet been provided
$23 USD en 1 día
5,0 (2 comentarios)
2,1
2,1
Avatar del usuario
Hello sir, I'm a Digital marketer. Expert on SEO & SMM. But new in freelancer. In local market I recently did many more project. I’m very passionate. Client satisfaction is my first target. If you interested to send me your project Inbox I then I will describe my portfolios. Inbox me Regards Bijon
$50 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I would like to offer myself as a probable candidate for this assignment as I am confident of delivering the same with quality output. . I have 7 years of IT experience in java, j2ee,SQL and am looking forward to prove my expertise in this forum as well.
$25 USD en 1 día
0,0 (0 comentarios)
1,9
1,9

Sobre este cliente

Bandera de UNITED STATES
Charleston, United States
5,0
137
Forma de pago verificada
Miembro desde oct 6, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.