SELECT ObjectId, Properties_ParticipantID, Properties_SpecimenID, Properties_DrawDate, Properties_HAIResDate, Properties_HAI_H1N12009, DataId
FROM (SELECT
Object.objectid AS ObjectId,
Object.objectid AS Properties,
Object.DataId AS DataId,
CAST((SELECT StringValue FROM exp.ObjectProperty WHERE exp.ObjectProperty.PropertyId = 1235 AND exp.ObjectProperty.ObjectId = Object.objectid) AS VARCHAR(4000))...