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 |
|
vaishanavi
Starting Member
9 Posts |
 Posted - 2009-03-20 : 03:52:51
|
| Hi,we are having 2 tables 1.one is order_of_birth i.e it will contain 2 columns 1 is id,2 is desc it contains totally 15 records2. the other is age of mother Age_limits it will contain 2 columns 1 is id,2 is desc it contains 9 records like ages like below15,15-1p,20-24,25-29,30-34..... the thing is we have to calculate the count the ageofmothersif birth_code=1 and below 15if birthcode=2 and belot 25-29can any one suggest that which loop is efficient if it is for loop then what is the syntax ..plz |
|
|
|
|
|
unable to know which loop is to be used