SQL Query to extract specific lists of values from E-Notebook tables

SQL Query to extract specific lists of values from E-Notebook tables

- Open the SQL Server Management Studio, if you don't have it you can download it here:
http://www.microsoft.com/en-us/download/details.aspx?id=8961
- Right-click the CSNotebook12 Database and select "New Query"
Paste the following SQL script:
-------------------------------------------------------------------------
Select
s.primary_key as section_key,
s.collection_key as collection_key,
p.name as property_name,
f.name as field_name,
tr.primary_key as row_key,
tr.position as row_position,
tc.enteredvalue as entered_value,
tc.min_value as min_value,
tc.chemical_structure_key,
tc.datevalue - (tc.time_zone_bias / 1440.0) as datevalue
FROM
ELN_sections s,
ELN_collection_types ct,
ELN_table_rows tr,
ELN_table_properties tp,
ELN_properties p,
ELN_table_cells tc,
ELN_fields f
Where
s.section_type_key = ct.section_set_key
and s.primary_key = tr.section_key
and s.primary_key = tp.section_key
and f.primary_key = tr.field_key
and f.primary_key = tp.field_key
and f.primary_key = p.field_key
and p.primary_key = tp.property_key
and tr.primary_key = tc.row_key
and tp.primary_key = tc.property_key
and tr.version_deleted is null
and f.name = 'Solvents';
-------------------------------------------------------------------------
Replace the field name(f.name) to 'Reactants' or any other Value so you can change the results of the Query.