Querry giving incorrect result

From: Simon (simon_at_bsctech.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 14:35:22 -0700

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

  • Querry giving incorrect result
    ... when i do a querry in an infinate loop ... Then insert an entry in BADDATA table. ...
    (microsoft.public.sqlserver.mseq)
  • 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)
  • Re: Querry giving incorrect result
    ... insert into BADDATA ... from TableA ... > when i do a querry in an infinate loop ...
    (microsoft.public.sqlserver.programming)