sql - Want to Select each field based on another field and create new columns for each -

hopefully explaining well. have stored procedure use populate report in crystal. need change of fields need pull 2 fields single column designated 2 different keys.

both fields have same job number searchable field used select records. trying fill 1 field in based on spare5 = , other on spare5 = b. create new columns hold each item number (item_numb_sparea, item_numb_spareb). possible? new sql , think simple it's haven't encountered yet.

you make 2 formulas in crystal reports pulls data out want.

it depends on if need stored procedure other things not require or change cause problems elsewhere. if unsure create formulas.

here info on creating conditional formulas in crystal reports.

if choose change stored procedure should simple, core of procedure select statement.

here info on modifying stored procedure.