HI,

Here is my table

CREATE TABLE [dbo].[CallActivity](
	[Activity] [nvarchar](max) NULL,
	[Id] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[AccountCallId] [uniqueidentifier] NULL,
	[SS] [bit] NULL,
	[ST] [bit] NULL,
	[SA] [bit] NULL,
	[OC] [bit] NULL,
	[EC] [bit] NULL,
	[BR] [bit] NULL,
	[SP] [bit] NULL,
	[IFs] [bit] NULL,
	[PO] [bit] NULL,
	[MB] [bit] NULL,
	[DS] [bit] NULL,
	[DSS] [bit] NULL,
	[ISs] [bit] NULL,
	[WD] [bit] NULL,
	[LT] [bit] NULL,
	[SRA] [bit] NULL,
	[SRB] [bit] NULL,
	[SRC] [bit] NULL,
 CONSTRAINT [PK_CallActivity] PRIMARY KEY CLUSTERED

Same AccountcallId can have many records, I want create query to display AccountcallId and count of true values of each bit fields

How can i do that