set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[sp_appraise]
@DailyWages numeric(15,3),
@Level int,
@empid int,
@daysofworking int
as
declare @gross numeric(15,3),@special_allowance numeric(15,3),@med_allwnc numeric(15,3),@HRA numeric(15,3),@deduction numeric(15,3)
declare @pttax numeric(15,3),@pf numeric(15,3),@it numeric(15,3),@NetAmount numeric(15,3),@Basicsalary numeric(15,3)
begin
set @Basicsalary=@DailyWages*@daysofworking
set @special_allowance=@Basicsalary*0.08
set @med_allwnc=@Basicsalary*0.15
set @HRA=@Basicsalary*0.10
set @gross=@special_allowance+@med_allwnc+@HRA+@Basicsalary
if @Level = 1
set @pttax = 250
if @Level = 2
set @pttax = 300
if @Level = 3
set @pttax = 400
if @Level = 4
set @pttax = 500
set @pf=@gross * 0.15
set @it=@gross * 0.10
set @deduction=@pttax + @pf + @it
set @NetAmount=@gross - @deduction
select @empid as EmployeeCode,@DailyWages as Daily_Wages,@Level as Level,@daysofworking as Days_Of_Working,@Basicsalary as Basci_Salary,
@special_allowance as Special_Allowance,@med_allwnc as Medical_Allowance,@HRA as HRA,@gross as Gross_Salary,@pf as PF,@it as IT_Tax,@deduction as Total_Deduction,@NetAmount as NetAmount
end
Sunday, November 6, 2011
Tuesday, May 17, 2011
Love – It’s the most selfish of all human emotions.
A catchy title!! But don’t u all think that love is indeed the most selfish of all our emotions. When in love we feel that only both of us should exist in our own space. There will be innumerable moments which I will feel of spending only with her. There will be thousands of topics which I will feel like discussing just with her. I would hate if she talks about someone (obviously some guy) constantly. I would want her to have the similar feelings for me.
Rather I think love is the “only” selfish emotion. I can share emotions like happiness, sadness, jealousy, frustration, depression with all my dear and closed ones and I feel one should be selfless regarding these emotions, especially happiness and sadness. God has created these emotions to share with our friends/closed ones.
Love teaches you to be selfish. Also emotions like possessiveness, obsession find birth in love…although they are an extreme form of it. But pure and unconditional love is what we all are searching for. Its becoming as rare as the snow leopards..and the ones who have found it are the blessed, lucky and fortunate ones…
I don’t know what I am thinking and writing about.. too abstract and making no sense.. I think its time for me to sleep. Good Night.
PS: Please don’t assume anything. Yet another random thought before going to bed.
Subscribe to:
Posts (Atom)
