I am Really confusing Please help me about a single query

Hi Guys,
This is my Problem.
A table contain following desing for handling different level of categories, bu it is dynamic

int_categoryid,
int_parent_categoryid,
int_categorylevel,
str_categoryname,
bit_active
thatall.
I want to list data from table as following order
categorry_parent11
category_child12
category_child13
category_child23
category_child22
categorry_parent21
..................
................................
.....................
like this..
ie we can insert parent category and sub category to n level dynamically without adding a new table
please mail me for another clarification...

please help me
regards
Abdul
For the example data you provided, can you tell us what data appears in the int_categorylevel column for each row?
categorry_parent11
category_child12
category_child13
category_child23
category_child22
categorry_parent21
|||

Thanks, tmorton
yes I am also interesting in int_categorylevel, and it gives the information about category level, 0,1,2 etc...
for Example Suppose we can take hotel menu categories...
Lunch Catgeroy level is 0
Veg Catgeroy level is 1
Average Catgeroy level is 2
Expensive Catgeroy level is 2
Non Veg Catgeroy level is 1
Chicken Catgeroy level is 2
Mutton Catgeroy level is 2
thanks ur response...

Hyperlink / Action Button

I am rendering reports using SQL reporting services. I would like a report
rendered with a hyperlink/action button that would contain an ID value that
will be used in rendering a new page...ie. I need to pass a row ID.
How can this be done?http://localhost/ReportServer?/<ReportFolder>/<ReportName>&rc:Toolbar=true&rs:Command=Render&RowID=1
Here is a sample url that can be click and will render a report passing it
the RowID parameter value.
Notice <ReportFolder> and the <ReportName> in the Url. You will need to
replace these with your data that makes since.
Bottom line is, you can dynamically create a Url that will render a report
to the browser based on the parameters passed in the Url.
I hope this makes sense.
Yosh
"tmiller" <tmiller@.discussions.microsoft.com> wrote in message
news:A67B3980-FBB2-4FA6-ADBC-597C400E0814@.microsoft.com...
>I am rendering reports using SQL reporting services. I would like a report
> rendered with a hyperlink/action button that would contain an ID value
> that
> will be used in rendering a new page...ie. I need to pass a row ID.
> How can this be done?