At 04:42 PM 08-10-02 +0100, you wrote:

>Could someone cast an eye over this SP below
>- I cannot get it to work properly
>
>The general idea is that the first SQL (the for loop)
>returns x rows (which in isolation it does) but when I add
>the second SQL, which determines how many of the measure I have
>it only returns the last row - or maybe I have it completely wrong

Just move your SUSPEND up inside the looping block and you will get one row
for each iteration of the block. Currently, you are only getting the last row.

heLen