Posted on: 10/9/2014 5:58:56 AM | Views : 367

Hello!
I'm experiencing very strange table behavior while perform queries against it:
1. When I'm doing left join
SELECT [ApprovalId] ,t.ApprovalTypeName FROM [AttendanceApprovals] a left join ApprovalTypes t on t.ApprovalTypeId=a.ApprovalType The ApprovalTypeName is null when the ApprovalType value is 11 (for id from 1 to 10 all works fine), but the value with id=11 is present in the ApprovalTypes table.
2. When I'm trying to delete a row by id:
delete AttendanceApprovals where ApprovalId=21913 it says 0 rows affected but there is row with the id=21913 and the select...where ApprovalId=21913 shows 1 row.
Some days ago all worked fine. I'm not sure what happened and how to fix this. Please, help.
So my table specifications:
CREATE TABLE [dbo].[AttendanceApprovals]( [ApprovalId] [ ...

Go to the complete details ...