I am definitely an novice in writing but trying to practice and get up to speed and would appreciate any help:
In laymen terms I have a quey that I am trying to write with the following columns TestName (where testname '1' = History, TestName '2'=Math, TestName '3'= Western Civilization, TestName '4'=Comp Apps, TestName '5'=Science. TestSource (Clep, DSST, Exelisor) Test Value (400,500,600,700,800,900) TestUnit (101,102,103,104) TestDte (datetime) When I pull these in an SSRS report it only returns one line of data I am trying to get a list, with the following results TestName TestSource Test Value TestUnit TestDte History Clep 500 101 10/1/2009 Math DSST 400 102 10/3/2009 I did try to use a case , but query only return one row, not sure how to use a loop in this instance. thanks in advance -Yvette _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users