Find Jobs
Hire Freelancers

create ms sql query

$10-30 USD

Terminado
Publicado hace alrededor de 5 años

$10-30 USD

Pagado a la entrega
have a ms sql data table with the fields per the attached pdf. I am wanting to have a query that will pull the records where "agent = 188" and it will pull the most recent (based on time in xtime field) from each lead number sorted so I have the most recent xtime record first - then the next most recent record from a different lead, then the next most recent record from a different lead. So the end result will be only one record from each lead - but they will be in descending order by xtime (most recent first) This will be a web page query not on direct interface - like starting from: strSQL = "SELECT * FROM textin2 WHERE (agent = 188)"
ID del proyecto: 18987892

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 5 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, I've worked with T-SQL at an advanced level for over twenty years, and I'm currently carrying out a number of projects on a freelance basis and I'm sure I'd be able to help with your query. I could do this right away for you. Please don't hesitate to contact me for more information. Kind Regards Steven
$25 USD en 1 día
5,0 (3 comentarios)
2,1
2,1
Avatar del usuario
Hi there, Yes I have no rate yet, but I have experience, and I am sure I will take my first 5 stars from you after I have done your job perfectly. I have read your project details and I think I am the right person which you are looking for. I have done many experience years in projects just like this, feel free to chat with me and we will get the right price and a perfect job I am waiting for your response.
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
9 freelancers están ofertando un promedio de $23 USD por este trabajo
Avatar del usuario
I am a technology solution architect and having more than 14 years of experience in IT industry. I can create query for you using partition and row_number. This will be achieved easily. Let me know if you want to discuss further. My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$30 USD en 1 día
5,0 (30 comentarios)
4,9
4,9
Avatar del usuario
Hi I read your post carefully. I have rich experience in mssql . I will satisfy your requirement on time. Please hire me.
$30 USD en 1 día
5,0 (3 comentarios)
1,7
1,7
Avatar del usuario
Hi, open your team viewer and let me help you where agent = 188 and xtime is MAX contaxct me for more information. thank you
$15 USD en 1 día
5,0 (3 comentarios)
1,4
1,4
Avatar del usuario
Hello, I am available right now. I can do the right job. You can trust me. This is my field of studies. I have 5 years experience on development. Thanks in advance. Best regards,
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
​I have a good skill set in MsSQL Server 2008/12/14/16, TSQL, Procedures, Functions, Views, Triggers, Performance tuning, Exception handling, Transactions. I can finish your work within a minute.
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Working on sql server
$25 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am sql developer
$25 USD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Davenport, United States
4,9
456
Forma de pago verificada
Miembro desde ene 3, 2003

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.