creating tables at runtime

From: Brina (anonymous_at_discussions.microsoft.com)
Date: 05/07/04


Date: Fri, 7 May 2004 05:36:42 -0700

Hi

i have a problem at hand can anyone help me out?

i have a table which contains rows . i want to create
another table at runtime that has as its columns the row
of the prev table. the number of rows are determined at
runtime as such the columns are determined only at runtime.

for example

i have table called MSP_Number_Fields in Microsoft Project
Server2003 database

i want each row of a particular column(Num_field) as
column for another table that will be created at runtime.

the no of rows are determined at runtime.

plzzzz help me



Relevant Pages

  • Re: Microsoft Project is a spreadsheet system software?
    ... Project is more like Excel than a database as all information is loaded. ... For any version of Project Server use public. ... For Microsoft Project companion projects, ... >> Actually it's more like a database...with some spreadsheet ...
    (microsoft.public.project)
  • Require query for Actual Work Per day
    ... I am using Microsoft Project 2000. ... I saved mpp file using Save As option with enabling 'Expand timephased data in database' option in Tools-Options-Save option, as a project database in Sql server. ... Using Resource Usage View, i am not able to make a query in Sql which will return me specific task, resource & hrs per day. ... I want to make a query which will return a result like timescaled calendar view appears in Task/Resource Usage View which shows "per day how many hrs a particular resource has worked for a specific task". ...
    (microsoft.public.project.vba)
  • Require query for Actual Work Per day
    ... I am using Microsoft Project 2000. ... I saved mpp file using Save As option with enabling 'Expand timephased data in database' option in Tools-Options-Save option, as a project database in Sql server. ... Using Resource Usage View, i am not able to make a query in Sql which will return me specific task, resource & hrs per day. ... I want to make a query which will return a result like timescaled calendar view appears in Task/Resource Usage View which shows "per day how many hrs a particular resource has worked for a specific task". ...
    (microsoft.public.project.vba)
  • Re: Missing DLL
    ... this NG deals with developments on Microsoft Project. ... I just developed a small app for a guy using VB / VBA, ... This app reads a text file and inserts the data in a Access Database / ... "The database contains a missing or broken reference to the file ...
    (microsoft.public.project.vba)
  • Re: How I dramatically sped up DB file updating
    ... > Yet, if it takes 28 seconds to update 500 records on a Access database, ... > I do not remember to have found noticeable speed differences when batch ... This approach isn't great...it doesn't give consistent times. ... Prev by Date: ...
    (comp.lang.pascal.delphi.misc)