|
The relation databases should change the existing structure to tree like structures so that items of a sub item should be clearly represented
|
|
|
|
|
Ummm, well and what is the question?
Regards
Sebastian
|
|
|
|
|
If I understood correctly, you want to create a recursion on a single table. For example like in Person table it could have a reference to boss. Something like:
CREATE TABLE Person (
PersonID int,
Name varchar(50)
BossID int REFERENCES Person (PersonID)
)
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
I've got to give you 5 for interpretation alone, I wonder of that is actually whet the Op was after, I have no idea what was being asked.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks, it was a guess based on few keywords like tree and sub item, but let's see. The answer may be off-topic.
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
I guess it's the elephant, right?
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
SQL Server 2008 supports the HierarchyId. Check it out;
http://msdn.microsoft.com/en-us/library/bb677290.aspx
|
|
|
|
|
hello all
i dont know much about DB Tables but a few days ago i had problem with some methods that retrive very complex results from several tables to generate one simple table
so i was thinking and told my co-worker why dont we create a table with dynamic number of columns and rows insted of rows only, all of them said it is bad idea and no one explaines why to me. and i have been surfing the internet for few days trying to figure out whats wrong with it. so if there is any trouble, anything at all? ca you please tell me
thank you
|
|
|
|
|
Hi,
generating tables with a dynamic number of columns is not really easy to achieve. One idea behind relational databases is, that you have fixed columns but a dynamic number of rows. So to implement sth. that will create and handle dynamic columns is (in my opinion) hard.
But let's have a look at the problem itself. What do you mean by "...from several tables to generate one simple table"? Is it "join" or something like this?
Regards
Sebastian
|
|
|
|
|
SeMartens wrote: But let's have a look at the problem itself. What do you mean by "...from several tables to generate one simple table"? Is it "join" or something like this?
i am not generating a DB Table, i am trying to generate a HTML and it will be sperated into several areas for both columns and rows
SeMartens wrote: that will create and handle dynamic columns is (in my opinion) hard.
this is what i ment, and actually it is not that hard to implement.
thank you anyway, but can you give me a spesific answer or more detailed ?
|
|
|
|
|
alright, then i misunderstood you.
You don't want dynamic columns in a database table, but in a html table? This could be done using asp.net. There you could create an asp:table and add columns to it (as much as you like).
Is it this what you meant?
|
|
|
|
|
Hakmeh Mohannad wrote: i am not generating a DB Table,
Discussing a table in a database forum would naturally lead to this assumption. In which case your collegues are correct.
Generating dynamic columns for output is fairly straight forward, look into pivot/unpivot in BOL. You could then bind the result to a datagrid. Caveat is if there are lots of columns your grid is too wide for a page.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi Experts
Can You Tell Me How To Make Certificate in SQL Server 2005.
And Use It In Client End
Thank u
|
|
|
|
|
|
how do i write connection string to sql server 2005 database resident on another computer
thanks
|
|
|
|
|
|
I've used the ConnectionStrings.com site so many times it's rediculous.  Great site!
Kyosa Jamie Nordmeyer - Taekwondo Yi (2nd) Dan
Portland, Oregon, USA
|
|
|
|
|
how do i specify the path to a file on another computer on the network using vb.net
thanks
|
|
|
|
|
The same way as when you asked in the correct forum. Don't cross post, its pointless.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Maybe it's just me, but I can't stand how Microsoft implemented XML in SQL Server, syntax wise, I mean, when it comes to selecting table data to XML. I always thought something like this made much more sense:
Select
Convert(xml, '<?xml version="1.0" encoding="utf-8" ?>
<Employees>
#foreach emp in emp begin#
<Employee id="emp.EmployeeID#">
<Manager id="#emp.BossID#">#emp.BossName#</Manager>
<Addresses>
#foreach addr in emp.Address1 begin#
<Address id="#addr.AddressID#">#addr.Address1 + " " + addr.City + ", " + addr.State + " " addr.ZipCode#</Address>
#end#
</Addresses>
</Employee>
#end#
</Employees>
') As EmployeeDoc
From
(
Select
emp.ID As EmployeeID
,emp.Name As EmployeeName
,boss.ID As BossID
,boss.Name As BossName
,addr.ID As AddressID
,addr.Address1
,addr.City
,addr.State
,addr.ZipCode
From
Employees emp
Left Join Employees boss
On emp.ManagerID = emp.ID
Inner Join EmployeeAddresses empaddr
On emp.ID = empaddr.EmployeeID
Inner Join Addresses addr
On empaddr.AddressID = addr.ID
Where
emp.TerminationDate Is Null
) tbl;
I'm still working on learning the current syntax, so maybe this is a bit of a soapbox, but I feel better now anyways. 
Kyosa Jamie Nordmeyer - Taekwondo Yi (2nd) Dan
Portland, Oregon, USA
modified on Monday, October 20, 2008 3:32 PM
|
|
|
|
|
i am MSc(computer science) student. i want overview of database design of "books searching". And internal view of database how we can search books through keywords.
|
|
|
|
|
|
How do i save image into sql server using vb.net
thanks
|
|
|
|
|
you can use this[^] 
Regards
|
|
|
|
|
Hi,
I have a USERS table
in which have the following fields
USER_ID,
COMP_ID,
PASSWORD
CREATED_BY
CREATED_DATE
DELETED_BY
DELETED_DATE
here created_by will contain that user id who is creating this user,
but i want your opinion on deleted_by and deleted_date
Is it feasible put this two field in this table or i put it in another table.
“You will never be a leader unless you first learn to follow and be led.”
–Tiorio
"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
