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
@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