|
Hi how to rewrite the following question, here 'history' table, used_life int datatype, ul_units varchar, ul_units may contain data of firings, starts, landings, how to use two calculated columns in same select statements here user will enter history of flights in hh and mm in two texboxes i am converting into minutes and storing, it is a simple select if it is like this but how to write this here i have to do all this conversion only when the ul_units are HH:MM and used_life>=60 else i have to print the data as it is above query giving syntax error can anyone help Thanks in Advance
(comments are locked)
|
|
@phani10695 Please move your question to the default forum. This is only for the site discussions. Moreover, The syntax error is there, since you are missing a comma(,) in between the columns. i.e. OR if you need to add these fields then remove naming the first column alias and add a + i.e. If something else is desired, please let us know
(comments are locked)
|

