Re: Querry giving incorrect result

From: Trey Walpole (treyNOpole_at_SPcomcastAM.net)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 16:44:52 -0500

why use a loop?

e.g.

insert into BADDATA (ID)
select ID
    from TableA
    where not exists
            (
            select *
                from TableB
                where ID=TableA.ID
            )

or

insert into BADDATA (ID)
select ID
    from TableA
    where ID not in (select ID from TableB)

"Simon" <simon@bsctech.com> wrote in message
news:13f801c42656$3837cb00$a001280a@phx.gbl...
> Big problem here that is getting me frustrated
> i have TABLE A and TABEL B
>
> TABLE A TABLE B
> ID DATA ID (FK to TABLE A) DATA
> 100001 = 100001
> | |
> 101000 101000
>
> So basically Table B's ID is identical with Table A since
> it is simply a FK to A's ID
> when i do a querry in an infinate loop
> IF TABLE A's ID
> is not in TABLE B's ID
> Then insert an entry in BADDATA table.
>
> Supposinly since talbe A and B's id is the same thing, i
> should not be able to catch anything in the BADDATA
> table..
>
> HOWEVER what i end up with is after i loop the querry for
> like an hour or 2 , i will start seeing some entry in the
> BADDATA Table where the ID listed is less then
> 100001 which this ID does NOT exist since the ID started
> FROM 100001.
>
> please if anyone can give me some idea here about what
> went wrong i would be VERY gratefull
>
>
>
>

Relevant Pages

  • Re: Querry giving incorrect result
    ... That is the exact code i use in the querry script ... The loop itself was a pointless infinite loop ... Cos i have been gettin some odd entry ... baddata table should not exist.. ...
    (microsoft.public.sqlserver.programming)
  • Querry giving incorrect result
    ... when i do a querry in an infinate loop ... Then insert an entry in BADDATA table. ...
    (microsoft.public.sqlserver.mseq)
  • Querry giving incorrect result
    ... when i do a querry in an infinate loop ... Then insert an entry in BADDATA table. ...
    (microsoft.public.sqlserver.programming)
  • Re: Querry giving incorrect result
    ... you can do this with the help of INSERT INTO...SELECT syntax. ... insert into baddata ... from tablea ... (select * from tableb ...
    (microsoft.public.sqlserver.mseq)