Вот вроде что то навоял))
Код:
BEGIN TRY
select
t1.FirstName,t1.LastName,t4.Name as divisionTitle,t2.JobTitle,t3.StartDate,t3.EndDate
from
person.person t1, HumanResources.Employee t2, HumanResources.EmployeeDepartmentHistory t3, HumanResources.Department t4
where
t1.BusinessEntityID = t2.BusinessEntityID and t2.BusinessEntityID = t3.BusinessEntityID and t3.DepartmentID = t4.DepartmentID
and (t3.EndDate > " + SaveText.Date +
" or t3.EndDate is null) and (t3.StartDate < " + SaveText.Date + " or t3.StartDate = " + SaveText.Date + ")"
END TRY BEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber; END CATCH;
где SaveText.Date нужное мне число - вроде нормально отрабатывает)))
А так спасибо - твой ответ кое-что прояснил!
