IF CONDITION1 IS TRUE: 
SELECT CustomerTenderID, CustomerSiteID, ContractPeriod, SupplierID
		FROM dbo.tnd_TenderSiteRateConsumptionView
		WHERE CustomerTenderID = @CustomerTenderID

IF CONDITION2 IS TRUE:
SELECT CustomerTenderID, CustomerSiteID, ContractPeriod, SupplierID
		FROM dbo.tnd_TenderSiteRateConsumptionView
		WHERE CustomerTenderID = @CustomerTenderID AND
						CustomerSiteID = @CustomerSiteID 

DECLARE RateList CURSOR FOR
		SELECT CustomerTenderID, CustomerSiteID, ContractPeriod, SupplierID
		FROM dbo.tnd_TenderSiteRateConsumptionView
		WHERE (BASED ON CONDITION)
		ORDER BY CustomerTenderID, 
					CustomerSiteID, 
					SupplierID, 
					ContractPeriod

	OPEN RateList
	FETCH NEXT FROM RateList 
	INTO	@CustomerTenderID, @ReturnedCustomerSiteID, @ReturnedContractPeriod, @ReturnedSupplierID
	WHILE @@FETCH_STATUS = 0
	BEGIN
		SET @rowNum = @rowNum + 1

		-- DO SOME FUNKY STUFF					


		FETCH NEXT 
		FROM RateList 
		INTO	@CustomerTenderID, @ReturnedCustomerSiteID, @ReturnedContractPeriod, @ReturnedSupplierID

quote:

---

Originally posted by dewacorp.alliances

It's a complex query I would say and the best approach is using CURSOR. It's construct in such away for the reporting services.

---