Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jimmasami

    Left join with null instead of where

    Thanks for the response Pattycake245, I'll try this today, it certainly looks like it might be exactly what I need. Cheers
  2. jimmasami

    Left join with null instead of where

    Thanks for the help twifosp. SELECT * FROM MonthlyActuals RMA WHERE CAST(STR(RMA.Year ,4,0) + '-' + STR(RMA.Month,2,0) + '-01' AS DATETIME) >= '01 Jun 2000' AND CAST(STR(RMA.Year ,4,0) + '-' +...
  3. jimmasami

    Left join with null instead of where

    There's about 2 pages of SQL that goes with this, but it is restricting the records returned in the recordset by using the NOT EXISTS, but maybe a LEFT JOIN on the main table (sorry not shown in the script) utilising a NULL value could be a more efficient way of restricting the recordset.
  4. jimmasami

    Left join with null instead of where

    I'm working on a very large database, I have this piece of SQL in my script, but I've been informed that there is a more efficient way of doing this by using LEFT JOIN and checking for Null, but I'm not sure how to do this, any suggestions would be greatly appreciated. ...AND NOT EXISTS (...

Part and Inventory Search

Back
Top