Excellent job !!

I've come up with something more complicated.... 🙂

If you are still "in the mood", there are two more "issues".

First is similar function which will calculate finish for given...

Thanks for replies.

What about performance issues when using...

Thanks for all replies.

After all this posts, I think I will do my best to try to convince my client to accept simple ever increasing Order numbers, based on Identity...

Thanks guys for answers.

I am fully aware of possible problems:

1. Overruns will never happen, meaning that client will never have more then 200 orders per year. If it will happen...

Thanks Michael.

I agree with you, but still my client wants to have numbering system as described. This is of course, only for end users, and this "key" has nothing with...

Now it works perfectly, many thanks Journeyman...

Thanks for the reply.

However, it won't be so easy. Problem is that history table (3) keeps only first and last date for particular resource belongs to some company. Of course,...