Hi..maybe I have misunderstood your question....but you ask that "want products ordered by category-wise "
from the table designs that you have provided I cannot see where " category" is defined?
Could you please clarify...thanks
Table Schemas
=============
Table : Dept
Column_name Type
dept_id int
parent_id int
dept_order int
name nvarchar(128)
Table : Dept_Product
Column_name Type
dept_id int
product_id int
product_order int
can you post some more info please
http://www.sqlservercentral.com/articles/Best+Practices/61537/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day