Re: Importing from another database on same server using SQL Server Express

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you for replying

I thought this post was considered dead, so I elected to repost the
question on microsoft.public.sqlserver.server. The syntax proposed by
"amish" on that group proved to work:

UPDATE [TestNew].[dbo].[tblProcedure]
SET [CPT] = TestOld.[CPT]
FROM [TestNew].[dbo].[tblProcedure] TestNew inner join
[TestOld].[dbo].[tblProcedure] TestOld
on
TestNew.[procedureID]=TestOld.[procedureID]



Hugo Kornelis wrote:
On 30 Oct 2006 11:19:51 -0800, John Hackert wrote:

Thank you for replying -

Even with these other techniques, I receive the same "multi-part
identifier...could not be bound" error. So, perhaps the root of the
problem is not the syntax of the query but something else. Any other
ideas?

Hi John,

Please post the COMPLETE query, and the COMPLETE error message. Use copy
and paste to prevent errors. That information can help us pinpoint the
problem.

--
Hugo Kornelis, SQL Server MVP

.

Relevant Pages

  • Re: SQL query question #2
    ... and having test data makes it easier to test. ... Hugo Kornelis, SQL Server MVP ... My SQL Server blog:http://sqlblog.com/blogs/hugo_kornelis ... E.g. if I query the above data with required values of 'b' and 'd'. ...
    (comp.databases.ms-sqlserver)
  • RE: Query from more than one table
    ... I could not find my repost. ... what year the target and the max are consistent to the month. ... > query to bring these down to 12 totals, ... I need to pull info from 2 tables: ...
    (microsoft.public.access.queries)
  • Re: Fetching Data from 2 tables and send in text File using query
    ... File so what can be the query to do so. ... How to embed this in DTS is beyond me, ... Hugo Kornelis, SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: How To Return A "Range Of Rows"??
    ... SET ROWCOUNT. ... there are no rows returned by your query. ... the proc later tries to set a negative ROWCOUNT. ... Hugo Kornelis, SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: How to create stats report for each day
    ... After running your query i am getting a lot of duplicate dates: ... reference date. ... Hugo Kornelis, SQL Server MVP ... My SQL Server blog:http://sqlblog.com/blogs/hugo_kornelis ...
    (comp.databases.ms-sqlserver)