HI Guys
I need help to write a query
I have a table
Employee:
empIDEmployeeName Task StartDt EndDt
1 xxx 1 1950-01-01 00:00:00.000 1979-12-31 00:00:00.000
2 yyy 2 1980-01-01 00:00:00.000 2009-06-30 00:00:00.000
3 aaa 3 2009-06-30 00:00:00.000 2010-01-31 00:00:00.000
4 bbb 4 2010-02-01 00:00:00.000 null
when I pass one variable with date like 20070101
I need check the date ranges and get the exact record(this case 2nd records)
View Complete Post