|
CREATE FUNCTION F_Get_IncommTaxx(@sal money) -- 2500000
RETURNS money
-- SELECT DBO.F_Get_IncommTaxx(300000)
AS
BEGIN
DECLARE
@R_sal MONEY=@sal-150000 -- 350000
DECLARE
@tax MONEY =0
IF(@R_sal>0 AND @R_sal<=100000)
BEGIN
SET
@tax=(@R_sal *10)/100
SET
@R_sal=@R_sal-100000
END
ELSE IF(@R_SAL>0)
BEGIN
SET
@tax=(100000 *10)/100 -- 10000
set
@R_sal=@R_sal-100000 -- 250000
END
-- 20% slab
if(@R_sal>0 AND @R_sal<=200000)
BEGIN
SET
@tax=@tax+((@R_sal
*20)/100)
SET
@R_sal=@R_sal-200000
END
ELSE IF(@R_SAL>0)
BEGIN
SET
@tax=@tax+((200000
*20)/100) -- 50000
SET
@R_sal=@R_sal-200000
END
-- 30% slab
IF(@R_sal>0 )
BEGIN
SET
@tax=@tax+((@R_sal
*30)/100) -- 65500
END
RETURN @tax;
END
|
Sunday, 15 December 2013
Create FUNCTION TO find TAX in sqlserver
Subscribe to:
Post Comments (Atom)
EMP, DEPT Sample script
/****** Object: Table [dbo].[DEPT] Script Date: 19-05-2016 06:58:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET A...
-
Step 1: Select the folder where your files exists. In my existing files, I want to remove "dbo." Step 2: Create one b...
-
Different types of temp tables Step 1: We have different types of temporary data storage objects, probably we call as temp tables. ...
-
How to Import Data from EXCEL to Destination Import data from excel through wizard Step 1: Choose your database where to import data ...
No comments:
Post a Comment