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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by norgrovm
-
Faster, faster!
I'd be tempted to write this as a procedure, although running the SQL from access may run the sql on the server, most likely sql server will have to develop an execution plan each time which may add some significant time to overall processing of a complex job. A stored procedure execution plan...- norgrovm
- Post #2
- Forum: Microsoft SQL Server: Programming
-
WHERE clause to get most recent value from another table
Hmmm i must be asleep this morning, i made the same mistake you made... :0) so what i meant to say was... get the clients that were entered today from tbl.entry, then select those clients that aren't part of that sub-query result... SELECT Client.ClientID, Client.LastName + ', ' +...- norgrovm
- Post #9
- Forum: Microsoft SQL Server: Programming
-
WHERE clause to get most recent value from another table
I'm not sure that you need to do the joins to get the result that you're after. I'd get the client id's from the entry table that have not had an entry today, then use them in your WHERE clause to return the client names you want. You could alternatively use a SELECT DISTINCT in the sub-query...- norgrovm
- Post #8
- Forum: Microsoft SQL Server: Programming
