The SQL implementation, if present, is updated, and if it does not exist, add

Alter procproc_datasummary asbegin    beginTrybegin Tran            --PV            --statistical information deposited in temporary tables            SelectShareduserid,platformid,CONVERT(varchar( -), CreateDate,111) asCreatdate,channelid,sharedmanagerid,COUNT(*) asQty into#PVData fromDbo. PvinfowhereSharedlevel=1 Group  byShareduserid,platformid,channelid,sharedmanagerid,CONVERT(varchar( -), CreateDate,111)            --Update will count the information that exists            UpdateDbo. DatasummarySetPV=dbo. #PVData. Qty from#PVDatawhereDbo. Datasummary.userid=dbo. #PVData. Shareduserid andDbo. Datasummary.platformid=dbo. #PVData. PlatformID andDbo. Datasummary.channelid=dbo. #PVData. Channelid andDbo. Datasummary.managerid=dbo. #PVData. Sharedmanagerid andDbo. Datasummary.summarydate=dbo. #PVData. Creatdate--Statistics of new PV information            Insert  intodbo. DatasummarySelectShareduserid,platformid,creatdate,channelid,sharedmanagerid,qty,0,0,0,0,0,0,GETDATE() fromdbo. #PVData awhere  not exists(Select *  fromDbo. DatasummarywhereDbo. Datasummary.userid=A.shareduserid andDbo. Datasummary.platformid=A.platformid andDbo. Datasummary.channelid=A.channelid andDbo. Datasummary.managerid=A.sharedmanagerid andDbo. Datasummary.summarydate=a.creatdate)--UV            --statistical information deposited in temporary tables            SelectShareduserid,platformid,CONVERT(varchar( -), CreateDate,111) asCreatdate,channelid,sharedmanagerid,COUNT(*) asQty into#UVData fromDbo. UvinfowhereSharedlevel=1 Group  byShareduserid,platformid,channelid,sharedmanagerid,CONVERT(varchar( -), CreateDate,111)            --Update will count the information that exists            UpdateDbo. DatasummarySetUv=dbo. #UVData. Qty from#UVDatawhereDbo. Datasummary.userid=dbo. #UVData. Shareduserid andDbo. Datasummary.platformid=dbo. #UVData. PlatformID andDbo. Datasummary.channelid=dbo. #UVData. Channelid andDbo. Datasummary.managerid=dbo. #UVData. Sharedmanagerid andDbo. Datasummary.summarydate=dbo. #UVData. Creatdate--statistics of new UV information            Insert  intodbo. DatasummarySelectShareduserid,platformid,creatdate,channelid,sharedmanagerid,qty,0,0,0,0,0,0,GETDATE() fromdbo. #UVData awhere  not exists(Select *  fromDbo. DatasummarywhereDbo. Datasummary.userid=A.shareduserid andDbo. Datasummary.platformid=A.platformid andDbo. Datasummary.channelid=A.channelid andDbo. Datasummary.managerid=A.sharedmanagerid andDbo. Datasummary.summarydate=a.creatdate)Commit Tran    EndTrybeginCatchrollback Tran    EndCatchEnd