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 Wanet Telecoms Ltd 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: Skylinc
  • Content: Threads
  • Order by date
  1. Skylinc

    Transposing Columns to Rows

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

Part and Inventory Search

Back
Top