DECLARE @w DECIMAL(16,6)
DECLARE @x DECIMAL(16,6)
DECLARE @y DECIMAL(16,6)
DECLARE @z DECIMAL(16,6)

SELECT 
      @w = RAND() * 33,
      @x = RAND() * 33,
      @y = RAND() * 33

SET @z = 100 - @w - @x - @y
SELECT @w,@x,@y,@z, 
      TOTAL = @w+@x+@y+@z