Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION Func (@number INT)
- RETURNS VARCHAR(32)
- AS BEGIN
- DECLARE @dpd VARCHAR(64)
- ;
- WITH
- _Range (i) AS
- (
- SELECT 1
- UNION ALL
- SELECT i + 1
- FROM _Range
- WHERE i !> 5000
- )
- , Main AS
- (
- SELECT i
- , CASE
- WHEN i BETWEEN 1 AND 50 THEN '1-50'
- WHEN i BETWEEN 51 AND 90 THEN '51-90'
- WHEN i BETWEEN 91 AND 180 THEN '91-180'
- WHEN i BETWEEN 181 AND 250 THEN '181-250'
- WHEN i > 250 THEN '250+'
- END attr_1
- , CASE
- WHEN i BETWEEN 1 AND 1000 THEN '1-1000'
- WHEN i BETWEEN 1001 AND 2000 THEN '1001-2000'
- WHEN i BETWEEN 2001 AND 3000 THEN '2001-3000'
- WHEN i BETWEEN 3001 AND 4000 THEN '3001-4000'
- WHEN i BETWEEN 4001 AND 5000 THEN '4001-5000'
- END attr_2
- FROM _Range
- )
- SELECT @dpd = CONCAT(attr_1, ', ', attr_2)
- FROM Main
- WHERE i = @number
- OPTION (MAXRECURSION 0)
- ;
- RETURN @dpd
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement