Re: Modifying temporary tables errors

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul Lush (paul.PS_AM.lush_at_bbc.spam.me.co.uk)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 11:57:08 -0000

Nope, those are copy/pasted from the QA window. Im going to try to inner
join two huge queries instead.

Thanks for the help guys!

"Chandra A" <csapatnaik@hotmail.com> wrote in message
news:OUjG6tF$DHA.2524@tk2msftngp13.phx.gbl...
> Update works fine on temporary tables.
> you might have tried the update in another instance of the Query Analyser
>
> best regards
> Chandra A
>
>
> "Paul Lush" <paul.PS_AM.lush@bbc.spam.me.co.uk> wrote in message
> news:c1kj9a$spp$1@nntp0.reith.bbc.co.uk...
> > MSSQL 2000 SP3 and Im trying to add a column to a temporary table as the
> > real table is huge
> >
> > SELECT DataT.* INTO #ptable FROM DataT
> >
> > ALTER TABLE #ptable ADD NEWCOLUMN int
> >
> > UPDATE #ptable SET #ptable.NEWCOLUMN = 1
> >
> > The update reports back
> >
> > Server: Msg 207, Level 16, State 1, Line 3 Invalid column name
> 'NEWCOLUMN'.
> >
> > but if you select * from #ptable, it shows the NEWCOLUMN
> >
> > Any ideas how to do this instead of creating a new table, inserting
values
> > in a huge (I mean HUGE - 120 columns) INSERT INTO
> >
> > Many thanks
> >
> > Paul
> >
> > paul.lush.hates.spam@spam.sucks.bbc.co.uk
> >
> > remove the obvious :-)
> >
> >
> >
>
>

Relevant Pages

  • Re: Custom Menu
    ... I had initially thought to use a form, but these queries are pivot tables ... The form opens in datasheet view just dandy. ... use a form to display these queries as a datasheet. ... the standard Access menu until the query window is closed. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help with puzzle on Stained Glass Window
    ... window so decided that it was definitely 1821 and not 1827. ... inner square section appearing to be of a better quality (although the outer ... It is possible that the main (outer glass) was made here and the inner ... square imported and inserted into the main glass. ...
    (soc.genealogy.britain)
  • Re: Front Window Marking
    ... I have used it quite a bit this year but only during our last weekend away did I notice some strange markings on the front window, Inside the sealed panel that looked like a grey mould. ... It was caused by wind pressure when driving causing the inner and outer faces to meet and rub together. ...
    (uk.rec.caravanning)
  • Re: Query training -- Complex queries
    ... As for your queries, the first one filters the rows to update with the JOIN. ... > Update PositionsEOM ... > from the result of the inner join on tableA and tableB). ... > I don't know where to come across such learning; SQL Books Online sure ...
    (microsoft.public.sqlserver.server)
  • Re: Left Join Nested Query
    ... Sometimes you also have to break it into several queries when using Left ... Outer Joins in conjuncion with Inner or Cross joins. ... > You can take the SQL string you've created in VBA & put it into a ...
    (microsoft.public.access.queries)