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-08-02 : 09:01:24
|
| ridhi writes "HI team,need help with this one n its urgent :Have a category n product tables in SQL server.Category table can be viewed as a Hierachical struc. on guii.e each sub-category is linked to a parent categ. by col.Parent_OID.Eg : Apparel is Main Categ. whose child records areWomen , Men , Kids. Now , note that each of these recordsfurther have sub-categ. like Shirts , Trousers.This is to implement HTML links :apparel-women-shirts , apparel-women-trousers , n so on.PRODUCTS are defined in the DB@lowest categ. runk.Say in this case 'Apparel-Women-Shirts'.Question is : given the above background , need a queryto retrieve NEW Products under Apparel-Women-Shirts section.Can u help me out with this one ASAP.thanks n rgds.ridhi" |
|
|
|
|
|
query.