Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dEX2340
  • Content: Threads
  • Order by date
  1. dEX2340

    Using CONVERT in CASE WHEN

    I have a problem with below SQL code. Error message: "Error converting data type varchar to float." CASE WHEN ... THEN volatility else 'NA' end) as volatility So the field 'volatility' is of datatype 'varchar', while 'NA' is datatype 'float', right? I guess it can be solved by using CONVERT...
  2. dEX2340

    SQL: Select Case when ...

    Goal is to select data from a table ec_rates, but some conversion is needed to have the right data/column header in a csv file Please see 2 lines of data from the table and what I would like rate_code market_date bid ask mid FR.EUR.GBY.0.0.1 2012-03-14 0.32 0.32 0.32...

Part and Inventory Search

Back
Top