TSQL query for creating possible combinations

Dear freelancer, I have a sql server db with the following columns: Date, number1, number2, number3, number4, number5, number6 and few other columns. I need a tsql query that will create all possible combinations for numbers from 1 to 90 escluding occurences in database. For example, if there's already in db a combination such as 8, 11, 18, 46, 48, 88 then it should be excluded from the result set. Parameters to be accepted are as follows: NUMBERS TO BE EXCLUDED: set of number that should be excluded from result set CONTINUOUS NUMBERS YES/NO: Exclude from result set sequences with continuous numbers (eg. 12345 or 1, 2, 15, 16, 22, 23, etc) RANGE OF NUMBERS (FROM 1 TO 10): How many numbers to be included in result set RANGE OF NUMBERS (FROM 11 TO 20): How many numbers to be included in result set RANGE OF NUMBERS (FROM 21 TO 30): How many numbers to be included in result set RANGE OF NUMBERS (FROM 31 TO 40): How many numbers to be included in result set RANGE OF NUMBERS (FROM 41 TO 50): How many numbers to be included in result set RANGE OF NUMBERS (FROM 51 TO 60): How many numbers to be included in result set RANGE OF NUMBERS (FROM 61 TO 70): How many numbers to be included in result set RANGE OF NUMBERS (FROM 71 TO 80): How many numbers to be included in result set RANGE OF NUMBERS (FROM 81 TO 90): How many numbers to be included in result set Let me know if you have further questions or need a clarification on this task. Thank you