Thank you both for taking time to look at my problem.

Peter the code and link to the function have been incredibly helpful and have opened up a new avenue for...

Hi Jef, that is correct.

The account belongs to Bob for period 200801 - 200802 and to Fred from 200803 onwards.

G

Thanks for this.

Is there a benefit to using the Cross Apply , I've never used it before ...

Thank you everyone for taking time to post, you have been most helpful!

I went with Chris's solution as I found it easier to read (at least for me anyway :P)

I...

Hi,

To calrify Work Day is Monday to Friday. Holidays are not material for the purpose of this report.

I would like to avoid the use of calender table if at all...

Hi and thanks for the info, unfortunately we are running SP3 so it had to be something else.

Hi thanks for all the feedback. Apologies for not replying to this post sooner (i really thought i had :P)

In the end we used ORIGINAL_LOGIN() and used the result in...

Thanks both for the code samples, it is greatly appreciated!

Hi all,

I've been away on leave and have only recently had time to catch up.

Thanks for all the code samples you were extremely thorough :w00t:

Good article, especially since it shows both XP_CMDSHELL and the SQLCLR version.

I've never actually made use of SQLCLR but it looks like it may be the better solution for my...

Thanks, i'll give this one a read!

That could work ... thanks for the suggestion!

You can use the DatePart function to divide portions of the date but I don't believe you will be able to get the range from any built in function.

Cool thanks for the feedback, it's been bugging me for a while 😛

I maybe mistaken but I'm sure I read somewhere that TRUNCATE TABLE will be rejected if there is an FK pointing to the target table even if the FK table...