ID Code NameEn StarDate ShiftDayCount
1 1 A 2016-07-31 00:00:00.000 3
3 2 B 2016-07-31 00:00:00.000 3
4 3 C 2016-07-31 00:00:00.000 3
i want Send Date 2016-08-21 what is the Work Shift to return
i want Send parameter @DateNw = '08/08/2016'
Result
ID Code NameEn StartDate ShiftDayCount
4 3 C 2016-07-31 00:00:00.000 3
From the sample you gave us, why would row with id=4 qualify?
Depending on ShiftDayCount
Lets say your sample data is:
ID Code NameEn StarDate ShiftDayCount
1 1 A 2016-07-31 00:00:00.000 3
3 2 B 2016-07-31 00:00:00.000 3
4 3 C 2016-07-31 00:00:00.000 3
5 4 D 2016-08-01 00:00:00.000 3
6 5 E 2016-08-02 00:00:00.000 3
7 6 F 2016-08-03 00:00:00.000 3
8 7 G 2016-08-04 00:00:00.000 3
9 8 H 2016-08-05 00:00:00.000 3
10 9 I 2016-08-06 00:00:00.000 3
and you want send date 2016-08-05, which row(s) would qualify?