How can i use 2 Dimensional Array in SQL Stored Procedure

See more:

SQL

Hi how can i perform this function in sql stored Procedure using 2 Dimensional Array.

FETCH THE CURRENT DENOMINATIONS & AVAILABLE NUMBERS OF THE ASSIGNED_TO PARTNER AND ASSIGN IT TO ARRAY (NOTE: IF AVAILABLE NUMBER IS 0 THEN IT IS NOT COUNTED) 	
Define 2D Array; FOR EACH available denomination with stock assign the following:
Array(i,1) = Denomination ; Array(i,2) = Available Stock in number ; Array(i,3) = Allocated (INITALLY 0)

ACTUAL_ALLOT_QTY = 0
For Qty = 0 to MAX_ALLOT_LTR					
	Temp_Denom = 0					
	for i= 1 to Array Size					
		If Array(i,2) > Array (i,3)
   		      IF (ACTUAL_ALLOT_QTY + Array(i,1)) <= MAX_ALLOT_LTR
                                  ACTUAL_ALLOT_QTY = ACTUAL_ALLOT_QTY + Array(i,1)
		           Array (i,3) = Array (i,3) + 1			
		           Qty = Qty + Array (i,1)			
                                 ELSE
		            Temp_Denom = Temp_Denom + 1			
                                 END IF
		Else				
			Temp_Denom = Temp_Denom + 1			
		End If				
	Next i					
        IF Temp_Denom = Array Size THEN Qty = MAX_ALLOT_LTR		
Next Qty	

------------------------------------------------------------------------------------------------
Help me anybody.