Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
Now, this works fine for a single record. If I want weekdays I can add (AND businessday=1). It returns something like:
SELECT datHoraEntradaTrabalho, datHoraSaidaTrabalho, (SELECT COUNT(*) FROM Calendar WHERE CalendarDate BETWEEN datHoraEntradaTrabalho AND datHoraSaidaTrabalho) Dias FROM tblTipoTrabalho WHERE FK_ID_intEmpresa=41 AND FK_ID_intFuncionario=1451 AND strTipoTrabalho='X'
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!