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.
| Author |
Topic |
|
AndyV
Starting Member
3 Posts |
 Posted - 2007-12-05 : 18:33:32
|
| Hi guys, This is probably a very redundant question however it has stumped me. I'm creating a dataset to host on the web and in the raw data age groups where never defined and to have it readable and accessable on the net I would like to set some age groups up instead of having the list just count up from 1. Can someone please show me the SQL query for this as its the last thing I need for this dataset. eagerly waiting your responses Andy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-05 : 18:40:20
|
| Your problem is not clear. Please show us with a data example what you want.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
AndyV
Starting Member
3 Posts |
Posted - 2007-12-05 : 19:43:12
|
| My question is this, Currently in the dataset age is entered singly with all the other variables and in order for me to publish the dataset I need to have age grouped i.e 0-10 11-20 21-30 and so on so I am trying to create a new view that will allow me to have the age variable grouped into age groups, if that makes sense? regards,Andy |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-05 : 21:49:27
|
| What do you mean by dataset? Do you mean a .NET DataSet, a Reporting Services dataset, or something else? And please show us a database example of how your data is currently stored.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
AndyV
Starting Member
3 Posts |
Posted - 2007-12-05 : 22:35:17
|
| I can't actually show a data example as its classified information but i mean an SQL database, dataset is just the other word used around my office for the "unclean" databases which we then clean in SQL and import into a proprietary software for publishing sorry I should have used the correct terminology. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-05 : 23:20:56
|
| Yes you can show a data example. Sample data does not need to be actual data from your database. It needs to illustrate the problem for us. It can be about fruit or cars or whatever. Without data, it is very hard for us to help you since your posts provide very little information.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Creating data groups