50313083190396414780762016-09-09T09:33:15.0741188+08:00762016-09-09T09:33:15.0741188+08:00000falsefalse50313083190396414780762016-09-09T09:33:15.0741188+08:00762016-09-09T09:33:15.0741188+08:00000Moidfiyfalse当月新增报价单select a.id,rtrim(a.Code) 报价单号,rtrim(a.ClientName) 客户名称,CONVERT(varchar(100),a.DocDate, 23) 报价日期,rtrim(b.UserENName) 业务员 from dbo.t_op_Quote a left join dbo.t_bse_user b on a.StaffId=b.id where year(a.DocDate)=year(GETDATE()) and month(a.DocDate)=month(GETDATE())true<?xml version="1.0" encoding="utf-16"?><ArrayOfWhereObj xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />select a.id,rtrim(a.Code) 报价单号,rtrim(a.ClientName) 客户名称,CONVERT(varchar(100),a.DocDate, 23) 报价日期,rtrim(b.UserENName) 业务员 from dbo.t_op_Quote a left join dbo.t_bse_user b on a.StaffId=b.id where year(a.DocDate)=year(GETDATE()) and month(a.DocDate)=month(GETDATE())0601A报价日期升序