Create multiple temporary tables in SQL using with with

CREATE PROC [dbo].[Sp_visitcount](    @count INT) as BEGINDECLARE @current DATETIMESET @current=GETDATE(); withtodayvisittable as(    SELECTCorpname,COUNT(Corpname) asTodayvisit fromdbo. VisitrecordsWHERE  Year(Visittime)= Year(@current)     and MONTH(Visittime)=MONTH(@current)     and  Day(Visittime)= Day(@current)    GROUP  bycorpname), totalvisittable as(    SELECTCorpname,COUNT(Corpname) asTotalvisit fromdbo. VisitrecordsGROUP  bycorpname), QUERY as (    SELECTRow_number () Over(ORDER  byTodayvisitDESC, TotalvisitDESC) asRownum,totalvisittable.corpname,todayvisit,totalvisit fromtotalvisittable Left JOINTodayvisittable onTodayvisittable.corpname=totalvisittable.corpname)SELECTRownum,corpname,ISNULL(Todayvisit,0) asTodayvisit,totalvisit fromQUERYWHERERowNum<= @count END

Create multiple temporary tables in SQL using with with