|
|
Posted by Erland Sommarskog on 04/02/06 20:28
?? (lokalun@gmail.com) writes:
> It will be much better if u can give me some idea if I would like to do
> this:
>
> Previous quiz date | Previous quiz grade | Date | Time | Name | Grade |
> Next quiz date | Next quiz grade
>
> That is, if I show the 4th quiz detail, it will display the 3rd quiz
> date and grade and 5th quiz date and grade as well. Is that impossible?
>
> Please let me know if u want more information. Many thanks.
It is at this point that I will ask to provide:
o CREATE TABLE statements for your table.
o INSERT statemetns with sample data.
o The desired data given the sample.
This makes it easy to copy-and-paste test data into a query tool, and
develop a tested solution.
Moreover, if you don't give us a clear specification of what you want,
you cannot not get what you want.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|