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: SQLNewbiexaus
- Order by date
-
Return everything not in other table?
Iam sure this a simple one, but I still need help please?? I have these 2 script tables but I need to end up with one table which will return all records from the second table that are not in the first, so has been a status 97 but never been a status 5. Not sure if I should be nesting or...- SQLNewbiexaus
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
4 queries into 1???
Awesome thanks very much!- SQLNewbiexaus
- Post #3
- Forum: Microsoft SQL Server: Programming
-
4 queries into 1???
I have these 4 queries but I am new to SQL and I can't figure out how to put them into 1 table. Can someone please help? Select count (P.Pass) PastLight From Transactions T (nolock) Inner Join Invoicing I (nolock) on T.InvoicingID = I.InvoicingID Inner Join...- SQLNewbiexaus
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
