Re: Looping over a query

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 21:24:34 +0530

What is the schema 9of the RFMFactorLabels table?
Do you have a pk? Otherwise how you determine the order
of your rows??? 

-- 
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Chris" <christopher@reardenweb.com> wrote in message
news:%23I7VU5OlEHA.644@tk2msftngp13.phx.gbl...
> Hi all,
>
> I have a question on looping over results. I have the following select
> statement:
>
> SELECT FactorLabel
> FROM RFMFactorLabels
> WHERE ClientKey = @ClientKey
>
> The results would be something like:
> Frequency Group 1
> Frequency Group 2
> Frequency Group 3
> Frequency Group 4
> Frequency Group 5
>
> There will always be 5 results and only 5. I need to loop over the results
> and set them as:
> @Group 1 = "the first result"
> @Group2 = "the second result" and so on and so on.
>
>
> Can someone point me in the right direction?
>
> Thanks.
>
>
Loading