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...

Hyperthreading and Licensing

I like to know how many licenses are needed for a single processor machine
that has hyperthreading on and shows 2 CPU.
You only need to license the physical processors :-
www.microsoft.com/sql/howtobuy/SQLonHTT.doc
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:7FACC10E-BD3E-4F75-B0FD-7B99973512AD@.microsoft.com...
>I like to know how many licenses are needed for a single processor machine
> that has hyperthreading on and shows 2 CPU.
|||Assuming you use per processor licecing:
On license per physical processor that the OS can utilize.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:7FACC10E-BD3E-4F75-B0FD-7B99973512AD@.microsoft.com...
> I like to know how many licenses are needed for a single processor machine
> that has hyperthreading on and shows 2 CPU.

Hyperthreading and Licensing

I like to know how many licenses are needed for a single processor machine
that has hyperthreading on and shows 2 CPU.You only need to license the physical processors :-
www.microsoft.com/sql/howtobuy/SQLonHTT.doc
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:7FACC10E-BD3E-4F75-B0FD-7B99973512AD@.microsoft.com...
>I like to know how many licenses are needed for a single processor machine
> that has hyperthreading on and shows 2 CPU.|||Assuming you use per processor licecing:
On license per physical processor that the OS can utilize.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:7FACC10E-BD3E-4F75-B0FD-7B99973512AD@.microsoft.com...
> I like to know how many licenses are needed for a single processor machine
> that has hyperthreading on and shows 2 CPU.

Hyperthreading and Licensing

I like to know how many licenses are needed for a single processor machine
that has hyperthreading on and shows 2 CPU.You only need to license the physical processors :-
www.microsoft.com/sql/howtobuy/SQLonHTT.doc
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:7FACC10E-BD3E-4F75-B0FD-7B99973512AD@.microsoft.com...
>I like to know how many licenses are needed for a single processor machine
> that has hyperthreading on and shows 2 CPU.|||Assuming you use per processor licecing:
On license per physical processor that the OS can utilize.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:7FACC10E-BD3E-4F75-B0FD-7B99973512AD@.microsoft.com...
> I like to know how many licenses are needed for a single processor machine
> that has hyperthreading on and shows 2 CPU.