2d table structure

[bhartigurav26]

Hello,

I wanted to know if its possible to make a 2d table structure in SQL Server. Am aware of primary foreign key concept. But i intend to have in same table.

Is this possible??? and how??

[Goppi]

Hello,

I wanted to know if its possible to make a 2d table structure in SQL Server. Am aware of primary foreign key concept. But i intend to have in same table.

Is this possible??? and how??

It would be good if you could state the purpose for a 2d table? What do you want to achieve?

Goppi

[bhartigurav26]

education/ illiterate SSC HSC
occupation

Skilled Worked 3 5 5

Unskilled worker 5 6 9

This ia wht i have to achieve...
Hope this made you my ideas clear...

[Goppi]

education/ illiterate SSC HSC
occupation

Skilled Worked 3 5 5

Unskilled worker 5 6 9

This ia wht i have to achieve...
Hope this made you my ideas clear...

Looks like a simple table with 4 fields per record.

[bhartigurav26]

Its not just 4 fields there are about 7 fields horizontally and 6 fields vertically. Which makes a grid and store the summarised data in the table. its possible through primary- foreign key concept. But my question is wht if i need to put this in a single table then how to i go about doing tht..

[skhanal]

I am not clear what you are trying to achieve, post some sample data.

Also what is the need to put everything in one table?.