Problems with a SQL

[cwal]

It is wrong, since it always returns nothing.

INSERT INTO dbo.TBCONTABIL2002
(DATA, URL)
SELECT '260402' , A.URL
FROM tempTotalUrl A , TBCONTABIL2002 B
WHERE ('260402' <> B.DATA) AND (A.URL <> B.URL )

 

[tlbroadbent]

Try this.

INSERT INTO dbo.TBCONTABIL2002 (DATA, URL)
SELECT '260402' , A.URL
FROM tempTotalUrl A
WHERE NOT EXISTS
(SELECT * FROM TBCONTABIL2002
WHERE URL=A.URL AND DATA='260402') Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.

 

[cwal]

Thank you tbroadbent. Your suggestion works perfectly, you help me a lot.