sql server 2016 basic select issue

Question

I have basic database table with some rows. see the queries below. first query selects a record from the database.. you see the result. that result is not the same as the other two result. yet I am retrieving the same record from the table using the different columns/methods. correct record is the second and 3rd select queries.

PWTransferID is the primary key. PWtransfernumber is non clustered index/Unique

I am really confused and have never seen a problem like this. can anybody shed some light on this for me. almost like the database is broken some where.

Is that just a typo in the first query? Should 227 be 277? – Max Szczurek Apr 04 '17 at 16:38 — Max Szczurek, Apr 04 '17 at 16:38
Added as an answer - thank you! – Max Szczurek Apr 04 '17 at 16:45 — Max Szczurek, Apr 04 '17 at 16:45

score 2 · Accepted Answer · answered Apr 04 '17 at 16:45

2

Is that just a typo in the first query? Should 227 be 277?

answered Apr 04 '17 at 16:45

Max Szczurek

4,324
2
20
32

lol, stupid me. long day. thanks – Etienne Apr 04 '17 at 17:06

sql server 2016 basic select issue

1 Answers1