3초기억력

SET NOCOUNT ON Declare curGet_ViewSO1_PaperLog_Query CURSOR FOR select count(*) as count_all, convert(varchar(10), regdate, 121) as q_date, datepart(hh, regdate) as q_time, isnull(sum(cost),0) as countpay, mrd from SO1_Portal_Log where convert(varchar(10),regdate,121) = convert(varchar(10), dateadd(d,-1,getdate()), 121) and mrd in ('3800', '3802', '480', '4800', '6800', '390', '3806') and phone ..