• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Data Shaping in ASP

If I have a view that has 4 fields (customer, product, product type, date - all the fields are not unique and can be both parent or child) For example:

customer   product   product type   date
ABC          BEEF       FOOD             1/1/03
ABC          SHIRT     CLOTHES        2/6/03
BGH          APPLE     FOOD             7/7/02
BGH          BEEF       FOOD             7/7/02
CCC         SHIRT     CLOTHES        5/5/03

Can you show me how to use data shaping to select * the fields using 'product' as parent and select * the fields using 'product type' as child.
0
musclejack
Asked:
musclejack
  • 2
1 Solution
 
YZlatCommented:
select * from myViewOrTable
Order By product, product_type

I'm not sure what do you mean by select as parent and select as child
0
 
NowaYCommented:
musclejack,

I answered your last question be giving you an example of data shaping as requested.

Thanks,
Dominick
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now