Please include DDL with your questions so that we don't have to guess at what
your tables might look like.

Here's an example. Suppose you have a denormalized structure like this:

CREATE TABLE monthly_accounts (account_no INTEGER PRIMARY KEY, jan INTEGER
NULL, feb INTEGER NULL, mar INTEGER NULL, ...)

You can convert this to a more usable form as follows:

CREATE TABLE accounts (account_no INTEGER NOT NULL, dt DATETIME NOT NULL
CHECK (DAY(dt)=1), amount INTEGER NOT NULL, PRIMARY KEY (account_no, dt))

INSERT INTO accounts (account_no, dt, amount)
SELECT account_no, '20040101', jan
 FROM monthly_accounts
 WHERE jan IS NOT NULL
UNION ALL
SELECT account_no, '20040201', feb
 FROM monthly_accounts
 WHERE feb IS NOT NULL
UNION ALL
SELECT account_no, '20040301', mar
 FROM monthly_accounts
 WHERE mar IS NOT NULL
...

Notice that you will usually add at least one column to the key when you do
this.

Hi

I occasionally concatenate field names from sysColumn rows (by object) in
order to save myself the typing (in sprocs, etc.). Don't see any reason why
you couldn't add the values in your case (if this is what you're trying to
do).

example:

CREATE PROCEDURE dbo.sp_tablecolumns
@object_id varchar(100)
AS

DECLARE @FldCat1 VARCHAR(8000)
SET @FldCat1=''

SELECT @FldCat1=@FldCat1+(sysColumns.name + char(44))
FROM sysColumns with (NOLOCK)
WHERE id = object_id(@object_id)
ORDER BY sysColumns.colorder

PRINT @FldCat1
GO

usage: dbo.sp_tablecolumns 'MyTableNamethatIwantfieldsfor'

rob