I want to select true fields from a row

See more:

SQL-Server

database

Hi.

I have a table that is full of bit and int fields.
Any bit field has a same field as int , and it means every field that is true, so users need that item(request) ,and int field, means how many of that item they need.


like This :

CREATE TABLE [dbo].[tRequest](
    [RequestID] [int] IDENTITY(1001,3) NOT NULL,
    [UserID] [int] NULL,
    [ProductCatalog] [bit] NULL,
    [ProCatCount] [int] NULL,
    [SeminarDVD] [bit] NULL,
    [SeminarDVDCount] [int] NULL,
    [LenzTester] [bit] NULL,
    [LenzTesterCount] [int] NULL,
    [TrainCD] [bit] NULL,
    [TrainCDCount] [int] NULL,
    [AirAqua] [bit] NULL,
    [AirAquaCount] [int] NULL,
    [AirAstigma] [bit] NULL,
    [AirAstigmaCount] [int] NULL,
    [SoloAqua] [bit] NULL,
    [SoloAquaCount] [int] NULL,
    [FreshLook] [bit] NULL,
    [FreshLookCount] [int] NULL,
    [IcooneBrosh] [bit] NULL,
    [IcooneBroshCount] [int] NULL,
    [IcoonePro] [bit] NULL,
    [IcooneProCount] [int] NULL,
    [IcoondeCD] [bit] NULL,
    [IcooneCDCount] [int] NULL,
    [PDate] [nvarchar](50) NULL,
    [BroshStand] [bit] NULL,
    [BroshStandCount] [int] NULL,
    [LamaStandAqua] [bit] NULL,
    [LamaStandAquaCount] [int] NULL,
    [LamaStandFresh] [bit] NULL,
    [LamaStandFreshCount] [int] NULL,
 CONSTRAINT [PK_tRequest] PRIMARY KEY CLUSTERED
(
    [RequestID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tRequest]  WITH CHECK ADD  CONSTRAINT [FK_tRequest_TAccount1] FOREIGN KEY([RequestID])
REFERENCES [dbo].[TAccount] ([AccountID])
GO

ALTER TABLE [dbo].[tRequest] CHECK CONSTRAINT [FK_tRequest_TAccount1]
GO

I want to have a query that can select just that bit and int fields that the bit one is true.

Any suggestion?

Thanks in Advance.