Search results for query: *

Just to let you all know, that the biggest cause of my problem was in fact that I was using the old ODBC driver (as mentioned by Mike, thanks). I have since installed and started using the OLD DB diver, and all is sorted now. Thank you all for the help :D

The part of Mike's post that I will use is "two separate SELECTs, with six unions in each. Send the results to two temporary tables, then union the two tables into one final result." I already have the query split in two parts, and it does work, but merging the resulting CSV files into a...

Thanks for the responses guys. I will try MikeLewis's approach first (as it seems the simplest one), and if that doesn't work, then I will see if I can chat to the DB Admin to see if he could change the DB, although this seems unlikely. Thank you!

Hi all I have a table like this: cn_name, fcst1, fdate1, fcst2, fdate2, ... fcst12, fdate12 I would like to know how to write hte query to return a result like this: cn_name, fcst1, fdate1 cn_name, fcst2, fdate2 ... cn_name, fcst12, fdate12 At first it looks like i can use UNION ALL, but if...