摘要： ALTER PROCEDURE [dbo].[qryAppointmentworkStat]@startFrom smalldatetime,@endTo smalldatetime,@Type intasBEGINdeclare @surefromdate smalldatetimeif @startFrom is nullset @surefromdate=cast(convert(varchar(10),getdate(),120) as datetime)elseset @surefromdate=@startFrom;with cte_stat as(select app.creat 阅读全文