Wrox Programmer Forums
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 11th, 2006, 10:02 PM
Posts: n/a
Default column to rows

i konw this topic is quiete repetative but i think my prob is different
i have got a table like this

company id year units_jan units_feb units_mar....units_dec

 abx 1 2000 34 22 2234........77

I want to create a structure like this
Company year month units
 qqq 2000 1 34
           2000 2 22

how do i do that??
i have got about a million rows in my table

Old June 12th, 2006, 01:37 PM
Friend of Wrox
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

What is your purpose? What is the end use of the newly-arranged data going to be?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dealing with duplicate rows/column values SQLScott SQL Server 2000 2 September 29th, 2005 09:04 PM
Adding rows, AND column(s) to existing datatable cliffd64 VB.NET 2002/2003 Basics 1 August 18th, 2005 06:50 AM
How can I update 2 rows in one column in SQL table babou Classic ASP Databases 6 March 9th, 2005 11:13 AM
Limit rows returned and next rows minhpx General .NET 1 August 12th, 2004 06:25 AM
convert long column into rows bdmoody Classic ASP Basics 2 August 7th, 2004 01:11 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.