Advertisement
Guest User

Untitled

a guest
Nov 16th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.24 KB | None | 0 0
  1.  
  2. CREATE FUNCTION Func (@number INT)
  3. RETURNS VARCHAR(32)
  4. AS BEGIN
  5.  
  6.     DECLARE @dpd VARCHAR(64)
  7.     ;
  8.     WITH
  9.         _Range (i) AS
  10.         (
  11.             SELECT 1
  12.             UNION ALL
  13.             SELECT i + 1
  14.             FROM _Range
  15.             WHERE i !> 5000
  16.         )
  17.         , Main AS
  18.         (
  19.             SELECT i
  20.                 , CASE
  21.                     WHEN i BETWEEN 1 AND 50 THEN '1-50'
  22.                     WHEN i BETWEEN  51 AND 90 THEN '51-90'
  23.                     WHEN i BETWEEN 91 AND 180 THEN '91-180'
  24.                     WHEN i BETWEEN 181 AND 250 THEN '181-250'
  25.                     WHEN i > 250 THEN '250+'
  26.                 END attr_1
  27.                 , CASE
  28.                     WHEN i BETWEEN 1 AND 1000 THEN '1-1000'
  29.                     WHEN i BETWEEN 1001 AND 2000 THEN '1001-2000'
  30.                     WHEN i BETWEEN 2001 AND 3000 THEN '2001-3000'
  31.                     WHEN i BETWEEN 3001 AND 4000 THEN '3001-4000'
  32.                     WHEN i BETWEEN 4001 AND 5000 THEN '4001-5000'
  33.                 END attr_2
  34.             FROM _Range
  35.            
  36.         )
  37.    
  38.     SELECT @dpd = CONCAT(attr_1, ', ', attr_2)
  39.     FROM Main
  40.     WHERE i = @number
  41.     OPTION (MAXRECURSION 0)
  42.     ;
  43.     RETURN @dpd
  44.  
  45. END
  46. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement