FUNCTION [dbo].[DDVK]
(
	-- Add the parameters for the function here
	@DDVA int
)
RETURNS decimal(18, 2)
AS
BEGIN

   If @DDVA = 24  return 1.24;
   If @DDVA = 23  return 1.23;
   If @DDVA = 22  return 1.22;
   If @DDVA = 21  return 1.21;
   If @DDVA = 20  return 1.2;
   If @DDVA = 19  return 1.19;
   If @DDVA = 18  return 1.18;
   If @DDVA = 17  return 1.17;
   If @DDVA = 16  return 1.16;
   If @DDVA = 15  return 1.15;
   If @DDVA = 14  return 1.14;
   If @DDVA = 13  return 1.13;
   If @DDVA = 12  return 1.12;
   If @DDVA = 11  return 1.11;
   If @DDVA = 10  return 1.1;
   If @DDVA = 9  return 1.09;
   If @DDVA = 8  return 1.08;
   If @DDVA = 7  return 1.07;
   If @DDVA = 6  return 1.06;
   If @DDVA = 5  return 1.05;
   If @DDVA = 4  return 1.04;
   If @DDVA = 3  return 1.03;
   If @DDVA = 2  return 1.02;
   If @DDVA = 1  return 1.01;
  /* 
If @DDVA = 0  return 0; 
  */

  return 0;

END

UNCTION [dbo].[PresmetkaDDV]
               (@Cena Float , @Stapka int)
--RETURNS decimal(18, 8)
RETURNS Float
AS
BEGIN
  If @Stapka = 0  return @Cena - @Cena;
  If @Stapka <> 0  return @Cena - (@Cena / dbo.DDVK(@Stapka));
  
  /* 
If @DDVA = 0  return 0; 
  */

 return 0;

END