Find Jobs
Hire Freelancers

Calculate formula in SQL Server function

$10-30 USD

Terminado
Publicado hace más de 4 años

$10-30 USD

Pagado a la entrega
I have a function that is supposed to calculate the total amount a customer has to pay in land tax. There is a table that contains the chargelines that apply to the customer and the definition table is shown below. Some of the charges are fixed, while others consist of a formula that says {Width_of_land}*{Length_Of_Land}*2080 . I need to calculate the Total amount based on a couple of charge lines that are a combination of fixed and variable (formula) inside a SQL function that is shown below. create table tblTarrifLine (ID bigint identity not null, Description varchar(100), UnitRate decimal(18,2), TarrifType varchar(100) default 'Fixed', Formula varchar(100)) go Insert into tblTarrifLine (Description,UnitRate,TarrifType,Formula) VALUES('Line Charge',30,'Fixed','') Insert into tblTarrifLine (Description,UnitRate,TarrifType,Formula) VALUES('Property Tax',1,'{W}*{L}*6','Formula') Insert into tblTarrifLine (Description,UnitRate,TarrifType,Formula) VALUES('Medical Surcharge',1,'{W}*{L}*3','Formula') Insert into tblTarrifLine (Description,UnitRate,TarrifType,Formula) VALUES('Education Surcharge',1,'{W}*{L}*2','Formula') create PROCEDURE CalculateAmount @Qty decimal, @W decimal, @L decimal AS BEGIN Declare @TotalFixedCharges decimal(18,2) Declare @TotalVariableCharges decimal(18,2) SELECT @TotalFixedCharges=sum(UnitRate)*1 from tblTarrifLine WHERE TarrifType='FIXED' print @TotalFixedCharges --calculate the @TotalVariableCharges END GO
ID del proyecto: 23664232

Información sobre el proyecto

10 propuestas
Proyecto remoto
Activo hace 4 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
Proposal - I can help you derive formulae inside SQL function. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4) BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4) Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3) Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1) 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 (24 comentarios)
4,8
4,8
10 freelancers están ofertando un promedio de $33 USD por este trabajo
Avatar del usuario
Hi dear employer, I can assist you in calculating total amount for the land customer. Ping me so that i can solve and send you .
$50 USD en 2 días
5,0 (7 comentarios)
4,7
4,7
Avatar del usuario
Hi, I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I have attached my profile.  I am immediate available to join. I am ready to work any time zone. Thanks  Anil Patel 
$55 USD en 1 día
5,0 (5 comentarios)
3,3
3,3
Avatar del usuario
Hello. I have just read your description carefully. If you give me a chance i will work for you faithfully. As an experienced developer, I can solve your problems perfectly. I think I am appropriate for your project. Let me discuss more details with you. Looking forward to your reply.
$20 USD en 1 día
5,0 (2 comentarios)
2,9
2,9
Avatar del usuario
Hello Sir/Madam, I can start right now I am professional SQL developer with having more than 5 year's experience in this field. I read your project description and I am interested in it I need some more information related to your project Can we discuss the project ? I am waiting for your response Thanks
$40 USD en 2 días
5,0 (4 comentarios)
2,6
2,6
Avatar del usuario
Have 11 years experience in SQL, will be able to help you out. Relevant Skills and Experience Have 11 years experience in SQL, will be able to help you out
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello. I have read your proposal. It is easy job. I can help you. Please contact me. Regards.
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I am very experienced in SQL and I would be very glad to help you. If you are interested, please, contact me for further discussion. I have, also, some questions. Best regards, Milena Plamenac
$25 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SOMALIA
Hargeisa, Somalia
5,0
66
Forma de pago verificada
Miembro desde abr 13, 2015

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.