select id
    from   tbl
    group by id
    having sum(number) <= @given_value + 10
    and    sum(number) >= @given_value - 10

CREATE FUNCTION dbo.fnGetAnyCombination
(
	@WantedSum MONEY
)
RETURNS @Data TABLE (UniqueID VARCHAR(12) PRIMARY KEY, Number MONEY)
AS

BEGIN
	-- Stage the data
	DECLARE	@Stage TABLE (RowID INT IDENTITY(0, 1), Number MONEY, UniqueID VARCHAR(12))
	
	INSERT		@Stage
			(
				Number,
				UniqueID
			)
	SELECT		Number,
			UniqueID
	FROM		[Sample]

	-- Create the control mechanism
	DECLARE	@Control TABLE (Bit SMALLINT IDENTITY(0, 1) PRIMARY KEY, Value TINYINT)
	
	DECLARE	@Value TINYINT,
		@Mem TINYINT,
		@Items INT
	
	SELECT	@Items = COUNT(*),
		@Mem = 1
	FROM	@Stage
	
	INSERT	@Control
		(
			Value
		)
	SELECT	1
	
	WHILE @Mem < @Items
		BEGIN
			INSERT	@Control
				(
					Value
				)
			SELECT	0
	
			SELECT	@Mem = @Mem + 1
		END

	-- Work with the data
	WHILE EXISTS (SELECT NULL FROM @Control WHERE Value = 1)
		BEGIN
			INSERT		@Data
					(
						UniqueID,
						Number
					)
			SELECT		s.UniqueID,
					s.Number
			FROM		@Stage AS s
			INNER JOIN	@Control AS c ON c.Bit = s.RowID
			WHERE		c.Value = 1

			IF (SELECT SUM(Number) FROM @Data) = @WantedSum
				BREAK
			ELSE
				DELETE
				FROM	@Data
	
			SELECT	@Mem = 1
	
			UPDATE		@Control
			SET		@Value = CASE WHEN Value + @Mem = 1 THEN 1 ELSE 0 END,
					@Mem = CASE WHEN Value + @Mem = 2 THEN 1 ELSE 0 END,
					Value = @Value
		END

	RETURN
END

-- Prepare sample data
CREATE TABLE	[Sample]
		(
			UniqueID VARCHAR(12),
			Number MONEY,
		)

INSERT	[Sample]
SELECT	'a', -10 UNION ALL
SELECT	'b', 40 UNION ALL
SELECT	'c', 10 UNION ALL
SELECT	'd', -20 UNION ALL
SELECT	'e', 10 UNION ALL
SELECT	'f', 40

-- Show some results
SELECT -30, * FROM dbo.fnGetAnyCombination(-30)
SELECT -20, * FROM dbo.fnGetAnyCombination(-20)
SELECT -10, * FROM dbo.fnGetAnyCombination(-10)
SELECT 0, * FROM dbo.fnGetAnyCombination(0)
SELECT 10, * FROM dbo.fnGetAnyCombination(10)
SELECT 20, * FROM dbo.fnGetAnyCombination(20)
SELECT 30, * FROM dbo.fnGetAnyCombination(30)
SELECT 40, * FROM dbo.fnGetAnyCombination(40)
SELECT 50, * FROM dbo.fnGetAnyCombination(50)
SELECT 60, * FROM dbo.fnGetAnyCombination(60)
SELECT 70, * FROM dbo.fnGetAnyCombination(70)
SELECT 80, * FROM dbo.fnGetAnyCombination(80)
SELECT 90, * FROM dbo.fnGetAnyCombination(90)
SELECT 100, * FROM dbo.fnGetAnyCombination(100)

DROP TABLE [Sample]

create table test(id int, number money, uniqueid varchar(10) primary key)
insert test
select 33, 55, 'xde3'
union all select 65, 41, 'fed3'
union all select 33, 40, '65f3e'
union all select 33, 58.3, 'df54'
union all select 33, 40, 'fE2c'
union all select 33, 20, 'lbcE'
union all select 33, 20, 'Wqazx'
union all select 33, 40, 'Lgco#z'

-- pick the id we want to investigate
declare @id int; set @id = 33

;with cte(uniqueid,numberSum)
as
(
	select	cast(uniqueid as varchar(max)),number
	from	test
	where	id = @id
	
	union all

	-- note the delimiting character ',' must not exist in the uniqueid column!!! but you can choose any character
	select	a.uniqueid+','+b.uniqueid, a.numberSum+b.number
	from	cte a join test b
			on 	case when charindex(',',a.uniqueid) = 0
				then a.uniqueid
				else right(a.uniqueid,charindex(',',reverse(a.uniqueid))-1)
				end < b.UniqueID
			and b.id = @id
)
select	@id as id,*
from	cte
where	numberSum = 98.3
	--numberSum between 30 and 50

-- drop table test

id          uniqueid                             numberSum             
----------- ------------------------------------ --------------------- 
33          df54,fE2c                            98.3000
33          df54,Lgco#z                          98.3000
33          df54,lbcE,Wqazx                      98.3000
33          65f3e,df54                           98.3000

CREATE FUNCTION dbo.fnGetAllCombinations
(
	@WantedSum MONEY,
	@GetOnlyFirstMatch BIT = 1,
	@NicerLoopLook BIT = 0
)
RETURNS @Data TABLE (Loop INT, UniqueID VARCHAR(12), Number MONEY)
AS

BEGIN
	-- Stage the data
	DECLARE	@Stage TABLE (RowID INT IDENTITY(0, 1), Number MONEY, UniqueID VARCHAR(12))

	-- If all numbers are valid, add all but those equal to zero
	IF EXISTS (SELECT NULL FROM [Sample] WHERE Number < 0)
		INSERT		@Stage
				(
					Number,
					UniqueID
				)
		SELECT		Number,
				UniqueID
		FROM		[Sample]
		WHERE		Number <> 0
	ELSE
		INSERT		@Stage
				(
					Number,
					UniqueID
				)
		SELECT		Number,
				UniqueID
		FROM		[Sample]
		WHERE		Number > 0
				AND Number <= @WantedSum
		ORDER BY	Number DESC

	-- Create the control mechanism
	DECLARE	@Control TABLE (Bit SMALLINT IDENTITY(0, 1) PRIMARY KEY, Value TINYINT)
	
	DECLARE	@Value TINYINT,
		@Mem TINYINT,
		@Items INT,
		@Loop INT
	
	SELECT	@Items = COUNT(*),
		@Mem = 1,
		@Loop = 1
	FROM	@Stage
	
	-- Add a vertical binary counter
	INSERT	@Control
		(
			Value
		)
	SELECT	1

	WHILE @Mem < @Items
		BEGIN
			INSERT	@Control
				(
					Value
				)
			SELECT	0
	
			SELECT	@Mem = @Mem + 1
		END

	-- Work with the data
	WHILE EXISTS (SELECT NULL FROM @Control WHERE Value = 1)
		BEGIN
			INSERT		@Data
					(
						Loop,
						UniqueID,
						Number
					)
			SELECT		@Loop,
					s.UniqueID,
					s.Number
			FROM		@Stage AS s
			INNER JOIN	@Control AS c ON c.Bit = s.RowID
			WHERE		c.Value = 1

			IF (SELECT SUM(Number) FROM @Data WHERE Loop = @Loop) <> @WantedSum
				DELETE
				FROM	@Data
				WHERE	Loop = @Loop
			ELSE
				IF @GetOnlyFirstMatch = 1
					BREAK

			SELECT	@Mem = 1,
				@Loop = @Loop + 1

			UPDATE		@Control
			SET		@Value = CASE WHEN Value + @Mem = 1 THEN 1 ELSE 0 END,
					@Mem = CASE WHEN Value + @Mem = 2 THEN 1 ELSE 0 END,
					Value = @Value
		END

	IF @NicerLoopLook = 1
		UPDATE	d1
		SET	d1.Loop = (SELECT COUNT(DISTINCT Loop) FROM @Data AS d2 WHERE d2.Loop <= d1.Loop)
		FROM	@Data AS d1

	RETURN
END

-- Prepare sample data
CREATE TABLE	[Sample]
		(
			UniqueID VARCHAR(12),
			Number MONEY,
		)

INSERT	[Sample]
SELECT	'a', -10 UNION ALL
SELECT	'b', 40 UNION ALL
SELECT	'c', 10 UNION ALL
SELECT	'd', -20 UNION ALL
SELECT	'e', 10 UNION ALL
SELECT	'f', 40

-- Show some results for the sum of 20
SELECT * FROM dbo.fnGetAllCombinations(20, 1, 0)
SELECT * FROM dbo.fnGetAllCombinations(20, 1, 1)

SELECT * FROM dbo.fnGetAllCombinations(20, 0, 0)
SELECT * FROM dbo.fnGetAllCombinations(20, 0, 1)

DROP TABLE [Sample]

1	b	 40.0000
1	d	-20.0000

2	a	-10.0000
2	b	 40.0000
2	c	 10.0000
2	d	-20.0000

3	c	 10.0000
3	e	 10.0000

4	a	-10.0000
4	b	 40.0000
4	d	-20.0000
4	e	 10.0000

5	d	-20.0000
5	f	 40.0000

6	a	-10.0000
6	c	 10.0000
6	d	-20.0000
6	f	 40.0000

7	a	-10.0000
7	d	-20.0000
7	e	 10.0000
7	f	 40.0000