CREATE TABLE [dbo].[T_BODYPART](
[BodyPartIdentity] [bigint] NOT NULL,
[BodyPartName] [nvarchar](20) NOT NULL,
[BodyPartMemo] [nvarchar](50) NULL,
[DepartmentIdentity] [bigint] NULL,
[PriceIdentity] [int] NULL,
[DisplayOrder] [int] NULL,
[ReportNode] [nvarchar](255) NULL,
[ModalityTypeIdentity] [int] NULL,
[Protocolcode] [nvarchar](256) NULL,
[BodyPartCount] [int] NULL,
[EXPOSALCOUNT] [int] NULL,
[DisplayOrder2] [int] NULL,
[Price] [numeric](18, 2) NULL,
[BodyPartStoped] [smallint] NULL,
[BodyPartCode] [nvarchar](20) NULL,
CONSTRAINT [PK_T_BODYPART] PRIMARY KEY CLUSTERED
(
[BodyPartIdentity] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
这是病人报告表结构
SELECT TOP 1000 [F_STU_GUID]
,[F_STU_NUM]
,[F_STU_NAME]
,[F_STU_NAME_EN]
,[F_STU_SEX]
,[F_STU_AGE]
,[F_STU_BRITH]
,[F_STU_TELEPHONE]
,[F_STU_ADDRESS]
,[F_STU_PROFESSION]
,[F_STU_COMPANY]
,[F_STU_ID_CARD]
,[F_STU_NATION]
,[F_STU_MARRY]
,[F_STU_HEIGHT]
,[F_STU_WEIGHT]
,[F_STU_FEE_TYPE]
,[F_STU_IN_NUM]
,[F_STU_OUT_NUM]
,[F_STU_BUNK_NUM]
,[F_STU_SICKROOM_NUM]
,[F_STU_SICKROOM_AREA]
,[F_STU_FROM]
,[F_STU_MODEL]
,[F_STU_BODY_PART]
,[F_STU_METHOD]
,[F_STU_RESULT]
,[F_STU_SUSPICION]
,[F_STU_DISEASE]
,[F_STU_REFER_DOCTOR]
,[F_STU_REFER_OFFICE]
,[F_STU_REFER_DATE]
,[F_STU_PERFORM_DOCTOR]
,[F_STU_PERFORM_OFFICE]
,[F_STU_PERFORM_DATE]
,[F_STU_OPT_DOCTOR]
,[F_STU_OPT_DATE]
,[F_STU_WRITER]
,[F_STU_WRITE_DATE]
,[F_STU_OBSERVATION]
,[F_STU_DIAGNOSE]
,[F_STU_ADVICE]
,[F_STU_DETAIL]
FROM [PACS].[dbo].[T_STUDY_REPORT]
数据表[PACS].[dbo].[T_STUDY_REPORT]的检查部位字段[F_STU_BODY_PART]可以是多部位的。
比如：腹部+小器官+心脏，
然后我想做个统计，统计每天的每个检查部位和对应的操作次数和费用，请问怎么实现，请给个思路，贴上代码更好。
