/****** Script for SelectTopNRows command from SSMS  ******/
SELECT  [开单人]
	  ,[id] '订单号'
	  ,[date] '收款日期'
	  ,[money] '金额'
	  ,[bz] '收款项目名称'
	  ,[ren] '收款人'
      ,[paytype] '支付方式'
      ,[name1] '老板姓名'
      ,[name2] '影楼名称'
      ,[txtype] '套系类型'
      ,[taoxiname] '版本类型'
  FROM [Internal].[dbo].[dindanbukuanview##] where bz like '%服务费%' and [date] like '2014%' order by [开单人]

  SELECT  [开单人],sum(convert(int,[money],10)) '金额'
  FROM [Internal].[dbo].[dindanbukuanview##] where bz like '%服务费%' and [date] like '2014%' group by [开单人]