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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Last Working Day

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 query
2. INSERT INTO statements to populate the tables in step 1 with test data
3. Your query so far as executed against the tables from steps 1 and 2
4. The current output from your query when executed against the tables from steps 1 and 2
5. The desired output from your query when executed against the tables from steps 1 and 2
Go to Top of Page
   

- Advertisement -