CREATE TABLE DimentionsTable (Xmin int,Ymin int,Zmin int,Xmax int,Ymax int,Zmax int);
INSERT into DimentionsTable values(10,20,30,40,50,60)

ItemID  DimensionID  XVal YVal ZVal
1       1             10   20   30
1       2             40   50   60

quote:

---

Originally posted by grandhi

Hi All,

I don't know,is it correct question or not,but if it is doable,it will be useful in my database Design.

I want to store Cuboid dementions in my databse table,each cuboid dimention format is in following below.

{{xmin,ymin,zmin},{xmax,ymax,zmax}}.

I have 30 dimentions,all are same format what I mention above.

I want to create Table for this type of data.For this I tried with following code.after evaluation below code,it returns (1 row(s) affected)

CREATE TABLE DimentionsTable (Xmin int,Ymin int,Zmin int,Xmax int,Ymax int,Zmax int);
INSERT into DimentionsTable values(10,20,30,40,50,60)

Know,I connected DB through WolframMathematica.I fetching data from DB.but I am getting output like {10,20,30,40,50,60},Indirectly it returns first row values in list form.But I want the format {{10,20,30},{40,50,60}}.for this How can I make table.

I hope you understood,what I am trying.

is it doable?

Thank you.

---