>I have a table, with data:
>
> CREATE TABLE [dbo].[tblPivot2](
> [ref] [varchar](15) NOT NULL,
> [Age] [smallint] NULL,
> [Zip_Abbrev] [varchar](3) NULL,
> [Onset_Age] [smallint] NULL
> ) ON [PRIMARY]
>
> GO
> SET ANSI_PADDING OFF
>
> INSERT INTO [tblPivot]
> ([ref]
> ,[Age]
> ,[Zip_Abbrev]
> ,[Onset_Age])
> VALUES
> ('ND12988', 52, '452', 52)
>
> The result of
>
> select * from tblPivot
>
> is:
>
> ref Age Zip_Abbrev Onset_Age
> ND12988 52 452 52
>
> I want to query tblPivot and get the following as my result
>
> column_name column_value
> ref ND12988
> Age 52
> Zip_Abbrev 452
> Onset_Age 52
>
> Thanks in Advance,
>
> Andy