<div>
any answers greatly appreciated
</div>


<div>
'working days'<br />
<br />
How does your company define this? &nbsp;Most companies will have a custom table where each day is a row, and columns for fiscal year/month/week/whatever, working days, etc. <br />
<br />
Problem is, everyone has different holdiays, so what's a working day will vary wildly between companies and countries, such that a single SQL function won't cover all situations.
</div>


<div>
jim<br />
<br />
I think that sql is pretty good and i agree with your point about working days , our users are in US and UK.<br />
<br />
thanks.
</div>


<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim<br />
<br />
btw a TIME table is invaluable imho, for dealing with not only working days, but if your company has a really screwed up fiscal year such as crop year / federal year, and if fiscal months are 4-5-4 instead of straight calendar months.
</div>


<div>
<div class="content wysiwyg-content">
hi guys <br />
<br />
i have a table Sale_Region like<br />
<br />
<br />
sale_Date &nbsp; region &nbsp; &nbsp;customer_name<br />
<br />
2013-05-19 &nbsp; &nbsp; UK &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jay<br />
2013-03-1 &nbsp; &nbsp; &nbsp;US &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jack<br />
2013-05-22 &nbsp; &nbsp; AUS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jill<br />
2013-05-21 &nbsp; &nbsp; UK &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Anthony<br />
<br />
<br />
<br />
I want to return three columns max(sale_Date) , sale_Date which is 5 working days before &nbsp;max(sale_Date), <br />
region from the table<br />
<br />
any idea how i can do that?<br />
<br />
<br />
<br />
thanks
</div>
</div>


hi guys 

i have a table Sale_Region like


sale_Date   region    customer_name

2013-05-19     UK                  Jay
2013-03-1      US                  Jack
2013-05-22     AUS                 Jill
2013-05-21     UK                  Anthony



I want to return three columns max(sale_Date) , sale_Date which is 5 working days before  max(sale_Date), 
region from the table

any idea how i can do that?



thanks

fetching data from last 5 days

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.