Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.
USE [Billing Automation Processes] GO /****** Object: StoredProcedure [dbo].[Z4032P] Script Date: 10/15/2008 14:23:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[Z4032P] as begin DECLARE @Email nvarchar(255) DECLARE @Title nvarchar(100) DECLARE @body nvarchar(max) DECLARE @query nvarchar(max) DECLARE @attached nvarchar(max) DECLARE @agent nvarchar(60) DECLARE c1 CURSOR READ_ONLY FOR SELECT agent, email from [Billing Automation Processes].dbo.fakeagent OPEN c1 FETCH NEXT FROM c1 INTO @agent,@email WHILE @@FETCH_STATUS = 0 BEGIN set @attached = @agent+'_Customer_List.txt' set @query = 'select convert(nchar(25),CustomerName) as CustomerName, convert(nchar(10),ANI) as ANI, convert(nvarchar(25),CreateDate) as CreateDate, convert(nchar(10),[INTER CIC]) as [INTER CIC], convert(nchar(10),[INTRA CIC]) as [INTRA CIC] from [Billing Automation Processes].dbo.[Z4032 - NO LD Notification] where agent = '''+@agent+'''' set @body = 'Greetings '+@agent+', The following circuits have been added to U4. This email is to let you know that in the last 14 days since the circuit has been added we have not gotten traffic on the circuits. We would like for you to look over these circuits as we are concerned that you are not getting commissions and or the customer could be getting third party billing from another carrier. The following circuits have been setup with the following CIC codes listed below. If you believe a CIRCUIT listed below is a non usage circuit such as a Security or Credit card line, please contact agent support and let them know the circuit and what type of line. In addition provisioning has been notified about these circuits via an inquiry. This report will continue to generate until the circuits receive traffic or you notify support (firstname.lastname@example.org) of a change in circuit type to Switched Low Usage. ' EXEC msdb.dbo.sp_send_dbmail @recipients=@Email, @blind_copy_recipients= 'email@example.com', @body=@body, @subject='Customer List Attached', @profile_name='U4 Notifications.com', @query = @query, @execute_query_database = 'Billing Automation Processes', @attach_query_result_as_file = 0, @query_attachment_filename = @attached FETCH NEXT FROM c1 INTO @agent,@email END CLOSE c1 DEALLOCATE c1 END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.