yvette roberson <yvrober...@gmail.com> wrote: > 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.
>From your explanation, it's completely unclear what you are trying to do. >Realize that most of the participants here lack mind-reading abilities. Show >the following: - definition of your table (preferably the actual CREATE TABLE statement) - a sample of data in the table (results of "select * from mytablename" statement, or a representative subset thereof). - a verbal description of the goal you want to achive with your query - an expected resultset produced by that query from the sample data shown above. This information would make it much easier to help you. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
