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!
-
Congratulations gkittelson 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: *
- Users: bobchuckjim
- Order by date
-
Best way to write this query
I have found it quite difficult with this question and the other one you have posted to glean exactly what the expected output should be, for example what happens if the max date in ref 6 is not <= max date in ref 23, do we return 5 rows or just no value for the quantity for the ref 23 row ? In...- bobchuckjim
- Post #3
- Forum: Microsoft SQL Server: Programming
-
WHERE NOT IN???
a left join is another option... LEFT JOIN SQA_DASH_Report_Email ON SQA_DASH_Report_Email.Rel_ID = tmp_table.[Release ID] WHERE SQA_DASH_Report_Email.Rel_ID is null ...but you'd have to check whether its really any faster and less/more readable- bobchuckjim
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Find items not in another database... based on grouping
Hi, not 100% sure if you want to find missing records for document number or record id or both so will assume both. You can use a left join from db1 to db2 on recordid and docno and then add a where clause to identify those rows that are missing in db2 <pseudo code> select DB1..partyinfo.name...- bobchuckjim
- Post #2
- Forum: Microsoft SQL Server: Programming
