RE: creating tables at runtime

anonymous_at_discussions.microsoft.com
Date: 05/10/04 

Date: Sun, 9 May 2004 21:22:29 -0700

Hi

but can u explain to me this query .

i mean where do i specify the table name from where i
have to get the row as column?

thanks
brina
>-----Original Message-----
>Hi.
>
>You can utilize this:
>
>DECLARE @SQLString NVARCHAR(500)
>
>SET @SQLString = N'CREATE TABLE [Daily] (
> [InvoiceDate] [datetime] ,
> [ProdCode] [varchar] (20) ,
> [ProdQty] [numeric](20, 8) ,' + ' @p_Col_1 ' + '
[money] '
>)'
>
>EXECUTE sp_executesql @SQLString
>
>I expect that serve you.
>
>Hermilson
>MCDBA, MCSD
>Colombia
>
>**********************************************************
**
>
>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.
>.
>

Relevant Pages

  • Re: Using a Select Query to build a MDB table from a Fox table
    ... MS Access has a 'make-table' query with IN clause you can specify ... As you said the IN <database> clause is specific to Access SQL. ...
    (microsoft.public.fox.helpwanted)
  • Re: default select order
    ... database version is 10.2.0.1.0. ... Now I'm wondering why 10g2 works like this (every time I query)? ... Ei kaytossa (refers to E) ... If you do not specify an order by clause then the order the results come ...
    (comp.databases.oracle.server)
  • Re: Sort database alphabetically
    ... What I am saying is that you cannot sort the database, ... So all you need to do is add "ORDER BY Name" to your existing query. ... In the Query Designer screen use the Sort Order column to specify ...
    (microsoft.public.sqlserver.server)
  • Re: How to specify the name of the database to export to in a make table query
    ... parameter in the query rather than as something explicitly specified within ... I have tried IN [Enter filename and path]. ... >> I need to know whether it is possible to specify the name of a database ...
    (microsoft.public.access.queries)
  • Re: sort out one months
    ... MS Access MVP ... >I have a database of projects. ... > specific month how can I make query etc. ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
Loading