Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done 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.