Multiple rows in EXT01101 with the same Field_ID
Kevin Reed asked 7 years ago
I have a custom SSRS report that uses ext01101.strga255 to display extended company name. My SQL query joins on the ext01101 table where ext01101.field_id = 104. The issue is that there are multiple rows in this table with the same Field_ID. I’m assuming these are for different revisions, so how can I determine which record is correct / latest? Should I take the one with highest Extender_Record_ID? Or highest DEX_ROW_ID? Is there another table I can join in to determine which Extender_Record_ID is correct?
Extender_Record_ID
Field_ID
STRGA255
DEX_ROW_ID
2
104
Company Name
2
3
104
The Company Name
3
4
104
Name, The Company
4
Extender_Record_ID
Field_ID
STRGA255
DEX_ROW_ID
2
104
Company Name
2
3
104
The Company Name
3
4
104
Name, The Company
4
Answers
Mark Anderson Staff answered 7 years ago
based on your data, a user has entered 4 separate records,which is why you have 4 record ID’s in your system. Based on the highest Extender_Record_ID that would be the latest record added. As this is your data it would be hard to say which record you want. Which of the values are you showing the correct Company Name? If it is the one with Extender_Record_ID = 4 then select the max record ID.