P
pw2002uk
Guest
Hello all
I'm struggling to get the result I need from my linq to SQL query. I can find all of the person table records, or only the ones that have a corresponding date_table entry. This is the query I'm using, this results in only MK numbers 101 and 104 being returned. Numbers 100 and 105 are missed I guess because they don't have a valid record for today?
Where Person_data_table.MK = Date_Table.FK And Date_Table.Allocated <> "Vacation" And Date_Table.Allocated <> "Sick" And Date_Table.Date = Today And Person_data_table.Team = "A"
This is the table data (note Today is 15-Mar-20) - Please keep answers in VB, as C# answers don't tend to work after I have translated them! - Any help appreciated
regards
Peter
Continue reading...
I'm struggling to get the result I need from my linq to SQL query. I can find all of the person table records, or only the ones that have a corresponding date_table entry. This is the query I'm using, this results in only MK numbers 101 and 104 being returned. Numbers 100 and 105 are missed I guess because they don't have a valid record for today?
Where Person_data_table.MK = Date_Table.FK And Date_Table.Allocated <> "Vacation" And Date_Table.Allocated <> "Sick" And Date_Table.Date = Today And Person_data_table.Team = "A"
This is the table data (note Today is 15-Mar-20) - Please keep answers in VB, as C# answers don't tend to work after I have translated them! - Any help appreciated
regards
Peter
Continue reading...
