DECLARE DataFormula_cursor CURSOR FAST_FORWARD FOR        
select distinct Data_Formula, Query_Sequence 
from tbl_Data_Formula       
where App = @App And Area = @Area AND Status='active'        
order by Query_Sequence      

OPEN DataFormula_cursor         
FETCH DataFormula_cursor INTO @strSelect, @intQuerySequence  
WHILE @@FETCH_STATUS = 0        
BEGIN 
		IF @intQuerySequence = 1
		BEGIN       
			set @strSelect1 = @strSelect
		END 
		ELSE IF @intQuerySequence = 2
		BEGIN       
			set @strSelect2 = @strSelect
		END 
		ELSE IF @intQuerySequence = 3
		BEGIN       
			set @strSelect3 = @strSelect
		END 
		ELSE IF @intQuerySequence = 4
		BEGIN       
			set @strSelect4 = @strSelect
		END 
		ELSE IF @intQuerySequence = 5
		BEGIN       
			set @strSelect5 = @strSelect
		END 
		ELSE IF @intQuerySequence = 6
		BEGIN       
			set @strSelect6 = @strSelect
		END 
		ELSE IF @intQuerySequence = 7
		BEGIN       
			set @strSelect7 = @strSelect
		END 
		ELSE IF @intQuerySequence = 8
		BEGIN       
			set @strSelect8 = @strSelect
		END 
		ELSE IF @intQuerySequence = 9
		BEGIN       
			set @strSelect9 = @strSelect
		END 
		ELSE IF @intQuerySequence = 10
		BEGIN       
			set @strSelect10 = @strSelect
		END       
FETCH DataFormula_cursor INTO @strSelect, @intQuerySequence  
END        
	    
CLOSE DataFormula_cursor        
DEALLOCATE DataFormula_cursor 

quote:

---

Originally posted by jackv

Have you looked at CASE functionality?

Jack Vamvas
--------------------
http://www.ITjobfeed.com

---

select distinct Data_Formula, Query_Sequence 
from tbl_Data_Formula       
where App = @App And Area = @Area AND Status='active'        
order by Query_Sequence      

quote:

---

Originally posted by robvolk

Can we assume that the App and Area columns have only 1 row for each QuerySequence number?

---