Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Presentation of data

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-25 : 09:01:15
Tony writes "Hi Everyone, I want to be able to run a querry that will sub-categorise the data. This is how I will want it to look like:
eg:

MONDAY:

Conflakes
Rice
Pasta

TUESDAY:

Conflakes
Rice
Noodles


WEDNESDAY:

Frosties
Rice
Mash Potato


THURSDAY:

Frosties
Mash potato
Pasta

The whole idea is to sub categorise the data by the days in the week.

Please can someone help?


Tony"

nr
SQLTeam MVY

12543 Posts

Posted - 2002-02-25 : 09:26:08
What does the data you are querying look like?

==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -