Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RefreshSQL
Starting Member
1 Post |
 Posted - 2014-08-01 : 05:42:19
|
| Hi All,I am new to the forum so go easy on me.I am looking for a query that can return me all of the leads created in the last working day. So for example on a monday it will return the leads we recieved on friday.Could anyone give me any ideas?Thanks |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-01 : 11:39:59
|
| Add a WHERE clause to your query to limit the dates returned.BTW if you need more help, please post:1. CREATE TABLE statements to create the tables used in your query2. INSERT INTO statements to populate the tables in step 1 with test data3. Your query so far as executed against the tables from steps 1 and 24. The current output from your query when executed against the tables from steps 1 and 25. The desired output from your query when executed against the tables from steps 1 and 2 |
 |
|
|
|
|
|
Last Working Day