special sql string for rollcall

  • Hello

    the personels who works in oil rig, 14 days work. and 14 days rest.
    some of personels are Fixed and some of personels are not Fixed (Offset, or Alternative. I do not know what the English equivalent is)
    i wants to design a database for rollcall (Attendance).
    it is necessary to save records of personels who are not Fixed. but the fixed personels should not be saved in daily rollcall db.
    because it Leads to exacerbation (Expanded). only the daily record of personels who are not Fixed must be saved in db.
    now how can i get a sql string for data of a personels who are Fixed.

    i have 2 tables.
    first table have specifications of personels.(Fields: name, family, personelCode, FixedOrNot)
    and secode have record of rollcall..(Fields: personelCode, DateOfWork, RigName)

    Thanks

  • No idea what you are asking.  Sounds like homework to me

    For better, quicker answers, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Could be homework or it could that English is difficult for the OP and he (or she) is having difficulty expressing the problem in English.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply