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
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
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
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.
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
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
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