python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - not-exists

SQL: Insert Into Table 1 From Table 2 then Update Table 2 - Performance Increase

I am working to increase the speed and performance for a database process that I have inherited. The basic steps, prior to this process, is a utility uploads about a million or more records into an U...
test-img

Chris Donnelly

sql

sql-server

distinct

insert-update

not-exists

Votes: 0

Answers: 1

Latest Answer

Recommendations: You can disable triggers, foreign keys, constraints, and indexes before inserting and updating, after these processes you can enable all these again. Because indexes, triggers, and f...
test-img

Ramin Faracov

NOT EXISTS Vs. Left Outer Join

I am confused by the results that I am getting via the NOT EXISTS vs. LEFT OUTER JOIN with NULL. Consider the below 2 queries which produce very different results. Please note that the fkMasterPersonI...
test-img

rvphx

sql

sql-server

not-exists

Votes: 0

Answers: 1

Latest Answer

You need to correlate the exists subquery to the outer query. Here is one way: SELECT tl.pkLeadID, tl.fkMasterPersonID FROM dbo.tblPhoneLead tl WHERE NOT EXISTS ( SELECT 1 FROM dbo.tblInterne...
test-img

Tim Biegeleisen

Can you always use "NOT EXISTS" instead of "Not in"?

I have the Following Schema : Book(ISBN,Title,Genre) Published(ISBN,Publishernumber) The Query : What are the publisher numbers of the publishers that exclusively publish books of the genre “Computer ...
test-img

atassi122

mysql

not-exists

Votes: 0

Answers: 1

Latest Answer

To use NOT EXISTS you need to use a correlated subquery. SELECT p.Publishernumber FROM published p JOIN book b ON b.ISBN=p.ISBN WHERE b.Genre = "CS" AND NOT EXISTS ( SELECT 1 FR...
test-img

Barmar

How to use an UPDATE Query with an INNER JOIN to update fields within a table

I keep getting a run time error on the following SQL statement: UPDATE tbl_1 INNER JOIN tbl_2 ON tbl_1.PersNo = tbl_2.PersNo SET tbl_1.Marked = 'N/A' WHERE NOT EXISTS (SELECT * FROM tbl_2 WHERE tbl...
test-img

designspeaks

sql

sql-server

sql-update

inner-join

not-exists

Votes: 0

Answers: 2

Latest Answer

Part of the issue is SQL Server likes you to use table aliases and a FROM clause when using a JOIN with an UPDATE, and the SET comes before the tables: UPDATE t1 SET t1.Marked = 'N/A' FROM tbl_1 t1 I...
test-img

Joel Coehoorn

Posts

Questions

Blogs

Jobs