Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

warehouse table design


Hello (sql server 2000)

I have to build a table  that holds warehouse information

It should be letter of cell (a,b,c,d,....) and  number of cell
(1,2,3....300) , isempty  (bit default =0)

How would you create a table to hold such info like give all empty cells
under letter cell 'a'?

If I want to flll cell 'A'1=0  how would update the table?

Thanks

On 05.06.2007 15:02, Alex wrote:

> Hello (sql server 2000)

> I have to build a table  that holds warehouse information

What is this?

> It should be letter of cell (a,b,c,d,....) and  number of cell
> (1,2,3....300) , isempty  (bit default =0)

> How would you create a table to hold such info like give all empty cells
> under letter cell 'a'?

> If I want to flll cell 'A'1=0  how would update the table?

Looks like a spreadsheet.  What about:

create table excel_sheet (
   row_id varchar(1) not null,
   col_num int not null,
   value numeric(19) null,
   primary key pk_sheet (
     row_id,
     col_num
   )
)

create index...

        robert

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc