Posted by Eric J. Holtman on 05/21/05 19:04

sangleen@hotmail.com wrote in news:1116607729.750088.190080
@g14g2000cwa.googlegroups.com:

> If someone can give me an idea to do this in Ms-SqlServer:
>
> Create a order, this order I have to asign different location
> for each process of the order.
> Each location has a lasting time asigned in Hours.
> I have to determine the DateTime of begining and ending for
> each process, the order has the begining datetime.
>
> How can I determine the process DateTime(Begin,End)?
> I have to consider the WorkTime and Free-Days (Saturday, Sunday..).
> So when I create a new order the DateTime Asigned can not be used
> by another order still opened.
>
>


Is this a homework assignment?

[Back to original message]