Find Jobs
Hire Freelancers

Write a query for MSSQL 2008 R2

$10-30 USD

Terminado
Publicado hace más de 7 años

$10-30 USD

Pagado a la entrega
Use Excel worksheet attached. I have two tables: one for invoices and one for payments. There will be multiple customers and invoices/payments in each table. I need a query written that takes a date parameter. For that data, I need it to return an activity log showing all the activity a customer has had. All the invoices, payments, and also the debt that hasn't been paid for over 30 days. See the third worksheet for an example. If the project is completed successfully, this can lead to many more projects.
ID del proyecto: 12622967

Información sobre el proyecto

6 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
I am a freelance database programmer and i have a lot of experience with sql and queries and excel. i really think i can help you with your project. Thanks
$25 USD en 1 día
5,0 (15 comentarios)
3,8
3,8
6 freelancers están ofertando un promedio de $24 USD por este trabajo
Avatar del usuario
Hello Sir /Ms, I have received the specification of your project and I am sure to be able to the sql query I would like to talk to you more about the project Experience to apply: VB.NET / C # ASP.net / Win form MySql / Sql server Bootstrap About me I am a web developer focused on Microsoft technologies, I worked about 4 years developing web applications built using Asp.net and SQL Server 2005, 2008 and 2012.
$25 USD en 2 días
4,9 (36 comentarios)
5,0
5,0
Avatar del usuario
Third worksheet? But I found only two sheets in the given file. Is it because Iam using mac version of excel ? Please provide the Table Names and Structure, I will build you stored procedure which you can use and pass date parameter to get your desired results. Thank you.
$25 USD en 0 día
5,0 (2 comentarios)
3,5
3,5
Avatar del usuario
I'm expert in MSSQL
$30 USD en 0 día
5,0 (2 comentarios)
2,8
2,8
Avatar del usuario
Hey there, From the sounds of it, you need an SQL expert who can write optimized queries. Is that sounds about right? I have an extensive knowledge of MSSQL 2005, 2008R2, 2012. I have also a analytic background that could be a profit in your project. I've successfuly completed micorsoft exams 70-461 (Quering SQL Server 2012) and 70-462 (Administerinf SQL Server 2012). What is your favorite way to comunicate? Do you want activity for all customers (sorter by Id) or only for one? Do you want debt data in the same recordset as another row or in next recordset? Ps. This could be one of my first projects on Freelancer.com, so give me the chance to proof that i'm realy good business partner.
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Pembroke Pines, United States
5,0
9
Forma de pago verificada
Miembro desde sept 28, 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.