# Create Array_ref with list of case statements for array.
my $case = $case_query1->fetchall_arrayref();

#I get two case statements.
foreach $r (@{$case})
{
@case2 = join(", ", @{$r});
print "@case2"; 
}

# Count number of rows selected
my $num = $case_query1->rows;

#I get two case statements.
print "\n\nThis process returns $num of case statements.\n"; 

#I get one case statements.
print "@case2"; 

# Set up Query for Creating case data
my $case_stmt3 = "create table case_st_data1 as			         (SELECT
                     rd,
                     store_number
                     @case2
                  FROM
                    test_ptw_bottom_10
                  where
                    week_end_date in ('19-SEP-09','26-sep-09')
                  group by
                     rd,
                     store_number)";