Re: INSERT Problem

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

From: Gustavo (anonymous_at_discussions.microsoft.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 10:19:40 -0700

Thanks for the response Allan, but the syntax of my query
parses ok. It's just that I keep getting the error
message that the table OrderRegulation that already
exists is an invalid object.
Does the method require to create the tables as you did
in your query?
Thanks
Gustavo

>-----Original Message-----
>forget the
>
>OR rt.Col3 IS NULL
>
>
>in the INSERT. My hand got carried away.
>--
>--
>
>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>www.SQLDTS.com - The site for all your DTS needs.
>www.konesans.com - Consultancy from the people who know
>
>
>"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in
message
>news:ehpYvuLdEHA.1424@tk2msftngp13.phx.gbl...
>> Ok
>>
>> Let me offer an example
>>
>> CREATE TABLE Staging(col1 int, col2 int, col3 int,
primary key(col1,col2))
>> CREATE TABLE RealTable(col1 int, col2 int, col3 int,
primary
>key(col1,col2))
>> INSERT Staging VALUES(1,2,3)
>>
>> INSERT RealTable(col1,col2,col3)
>> SELECT s.col1,s.col2,s.col3
>> FROM Staging s LEFT OUTER JOIN RealTable rt
>> ON s.col1 = rt.col1 AND s.col2 = rt.col2
>> WHERE rt.col1 IS NULL OR rt.col2 IS NULL OR rt.Col3 IS
NULL
>>
>> INSERT Staging Values(1,3,2)
>>
>>
>> INSERT RealTable(col1,col2,col3)
>> SELECT s.col1,s.col2,s.col3
>> FROM Staging s LEFT OUTER JOIN RealTable rt
>> ON s.col1 = rt.col1 AND s.col2 = rt.col2
>> WHERE rt.col1 IS NULL OR rt.col2 IS NULL OR rt.Col3 IS
NULL
>>
>> SELECT * FROM RealTable
>>
>>
>>
>> --
>> --
>>
>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> www.SQLDTS.com - The site for all your DTS needs.
>> www.konesans.com - Consultancy from the people who know
>>
>>
>> "Gustavo" <anonymous@discussions.microsoft.com> wrote
in message
>> news:5c9b01c474ba$20b46990$a301280a@phx.gbl...
>> > Hi All(an):
>> > As I was advised I created this query:
>> >
>> > USE ipd
>> >
>> > INSERT INTO dbo.OrderRegulation
>> > (TitleId,YearId, MyIssue, RetId, IssueId, Location,
Draw,
>> > Reorder, [Returns], Cost, Price)
>> >
>> > SELECT StagingOR.TitleId, StagingOR.YearId,Stagin
>> > gOR.MyIssue, StagingOR.RetId, StagingOR.IssueId,
>> > StagingOR.Location, StagingOR.Draw,
>> > StagingOR.Reorder, StagingOR.
>> > [Returns], StagingOR.Cost, StagingOR.Price
>> > FROM StagingOR LEFT OUTER JOIN
>> > OrderRegulation ON
>> > StagingOR.TitleId = OrderRegulation.TitleId AND
>> > StagingOR.YearId = OrderRegulation.YearId AND
>> > StagingOR.MyIssue =
>> > OrderRegulation.MyIssue AND StagingOR.RetId =
>> > OrderRegulation.RetId AND
>> > StagingOR.IssueId =
>> > OrderRegulation.IssueId
>> > WHERE (dbo.OrderRegulation(StagingOR.TitleId,
>> > StagingOR.YearId, StagingOR.MyIssue, StagingOR.RetId,
>> > StagingOR.IssueId) IS NULL)
>> >
>> >
>> >
>> >
>> >
>> >
>> > that keeps returning the following error:
>> >
>> > Server: Msg 208, Level 16, State 1, Line 4
>> > Invalid object name 'dbo.OrderRegulation'.
>> >
>> > I am 1000% sure that the table exists and is not
>> > mispelled, the query syntax checks ok and I still
get the
>> > error.
>> > What is wrong??
>> > Thanks in advance
>> > Gustavo
>> >
>>
>>
>
>
>.
>

Relevant Pages

  • Re: Avoiding duplicates when importing
    ... Use it as the basis for your Append query from staging table to real table. ... > "Joe Fallon" wrote: ... Import the file using the wizard. ...
    (microsoft.public.access.externaldata)
  • Re: Updating existing records
    ... Thank you, Allan, for your helpful explanation. ... following a Data Flow in the Control portion of a package? ... Ok So Sue covers off staging tble nicely. ... task) now you will issue an UPDATE statement against the destination table ...
    (microsoft.public.sqlserver.dts)
  • Re: Using global variables
    ... (I cannot see a new value in a package as you are mentioned) ... > This Query will return a rowset to you. ... > Allan Mitchell MCSE,MCDBA, ...
    (microsoft.public.sqlserver.dts)
  • Re: How to automatically "map" the transformations in Transform Data Task?
    ... That's exactly what I'm trying to say: I might define my query in the DTS ... Designer as: ... It sounds like I need to tear down the transformations and rebuild them based on B. Do ... > Allan Mitchell MCSE,MCDBA, ...
    (microsoft.public.sqlserver.dts)
  • Re: How to automatically "map" the transformations in Transform Data Task?
    ... That's exactly what I'm trying to say: I might define my query in the DTS ... Designer as: ... It sounds like I need to tear down the transformations and rebuild them based on B. Do ... > Allan Mitchell MCSE,MCDBA, ...
    (microsoft.public.sqlserver.server)