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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-25 : 08:40:16
|
jai writes "I have two tables 1) dtl_member_primary
2) dtl_insurance
dtl_member_primary contains the foll. fields:
fname,mname,lname, dob,age, , cardnoprimary(primary key)
Now dtl_insurance contains foll.fields :
insurancecoid, cardnoprimary(foreign key) , amountinsured
I want to create a cross tab report taking age from dtl_member_primary and the amountinsured from dtl_insurance
Actually i want to group the amountinsured according to the age like:
Age(0-10) 11-20 21-30 31-40
Amountinsured
Plus in the database i do not have the age in the format in which i want to group. like 0-10 , 11-19.I have it from 1,2,3,4,5,6,7,8,9,------- goes on uptil 40
I hope someone will be able to answer my question
thanks
Jai" |
|
|
|
|
|
|
|
SQL: Creating a crosstab report