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...
-
TRUNCATE Data From All TABLES of a DataBase in SQL Server Here the following script help full to you to truncate data from all tables in...
-
Convert Delimited XML value in a column into Column (More than 8000 characters) To handle more than 8000 characters, convert that data in...
-
Different types of temp tables Step 1: We have different types of temporary data storage objects, probably we call as temp tables. ...
No comments:
Post a Comment