reduct field s

 USE [DellPII]

GO


/****** Object:  StoredProcedure [dbo].[SP_RedactFields]    Script Date: 3/29/2022 10:58:54 AM ******/

SET ANSI_NULLS ON

GO


SET QUOTED_IDENTIFIER ON

GO


      

-----------------------------------------------------------------                                                  

                                               

 --Initial Release: 28/01/2022     Author: Yogish                                                   

                                                    

-- EXEC SP_RedactFields                                   

                                                  

-----------------------------------                                                  

                                              

                                              

                                                  

CREATE PROCEDURE [dbo].[SP_RedactFields]                                

                                                       

                                              

AS                                                            

BEGIN                                                   

                  

               

            

DECLARE @START_TIME DATETIME, @END_TIME DATETIME,@c1 INT              

SET @START_TIME =GETDATE();                 

          

            

--Redaction         

-- We are updating  Redact value for NoteText for above Completion_datetime>90 days.              

UPDATE tb                          

SET tb.NoteText='REDACT'                                        

from Incident_SRMS_NOTES  tb                          

INNER JOIN [vw_UCAREPII_TXNS] Vw                          

ON tb.ATTENNO = Vw.Incident_Number       

WHERE VW.Datasourcename='SRMS' AND  tb.NoteText<>'REDACT'  --23           

        

SELECT @c1=@@ROWCOUNT               

              

              

BEGIN                    

                                    

                    

 UPDATE ST                   

 SET Row_count=@c1              

 ,STARTTIME=@START_TIME                    

 ,ENDTIME=GETDATE()               

 FROM SOURCETABLES ST              

 WHERE DATASOURCEID=42  AND ST.Datasourcename='SRMS'  AND  TABLENAME='Incident_SRMS_NOTES' AND FieldName IN ('NoteText')             

            

             

END               

        

SET @START_TIME =GETDATE();            

--We are updating  Redact value for Contact_FullName,Customer_Phone_Provided_1st,Call_type for above Completion_datetime>90 days.              

UPDATE tb                          

SET tb.Contact_FullName='REDACT'            

,tb.Customer_Phone_Provided_1st='REDACT'            

,tb.Call_type='REDACT'                               

FROM  Incident_SRMS_Specific  tb                          

INNER JOIN [vw_UCAREPII_TXNS] Vw                          

ON tb.Incident_Number = Vw.Incident_Number       

WHERE VW.Datasourcename='SRMS' AND  tb.Contact_FullName<>'REDACT' AND tb.Customer_Phone_Provided_1st<>'REDACT' AND tb.Call_type<>'REDACT'  --137819              

                 

         

SELECT @c1=@@ROWCOUNT               

              

BEGIN                    

                                  

                    

 UPDATE ST                   

 SET Row_count=@c1              

 ,STARTTIME=@START_TIME                    

 ,ENDTIME=GETDATE()               

 FROM SOURCETABLES ST              

 WHERE DATASOURCEID=42  AND ST.Datasourcename='SRMS'        

 AND  TABLENAME='Incident_SRMS_Specific' AND FieldName IN ('Contact_FullName','Customer_Phone_Provided_1st','Call_type')             

            

             

END           

        

          

SET @START_TIME =GETDATE();            

--We are updating  Redact value for CONTACT_CONTACT,CONTACT_COMPANY for above Completion_datetime>90 days.              

UPDATE tb                          

SET  tb.CONTACT_CONTACT='REDACT'            

,tb.CONTACT_COMPANY='REDACT'                              

FROM  Fs_Serviceincidents  tb                          

INNER JOIN [vw_UCAREPII_TXNS] Vw                          

ON tb.SOURCESR = Vw.Incident_Number       

WHERE VW.Datasourcename='SRMS' AND  tb.CONTACT_CONTACT<>'REDACT' AND tb.CONTACT_COMPANY<>'REDACT'           

        

        

 SELECT @c1=@@ROWCOUNT               

         

              

BEGIN         

                   

 UPDATE ST                   

 SET Row_count=@c1              

 ,STARTTIME=@START_TIME                    

 ,ENDTIME=GETDATE()               

FROM SOURCETABLES ST              

WHERE DATASOURCEID=42  AND ST.Datasourcename='SRMS'  AND TABLENAME='Fs_Serviceincidents' AND FieldName IN ('CONTACT_CONTACT','CONTACT_COMPANY')             

            

             

END              

        

           

SET @START_TIME =GETDATE();            

--We are updating  Redact value for ('COMPANY1','VOICEPHONE1','ALTERNATEPHONE1','FAXPHONE1','VOICEPHONE2') for above Completion_datetime>90 days.              

UPDATE tb                          

SET  tb.COMPANY1='REDACT'           

,tb.VOICEPHONE1='0'          

,tb.ALTERNATEPHONE1='0'          

,tb.FAXPHONE1='0'          

,tb.VOICEPHONE2='0'                           

FROM  Incident_Srms_Backlog  tb                          

INNER JOIN [vw_UCAREPII_TXNS] Vw                          

ON tb.SOURCESR = Vw.Incident_Number       

WHERE VW.Datasourcename='SRMS' AND  tb.COMPANY1<>'REDACT' AND tb.VOICEPHONE1<>'0' AND tb.ALTERNATEPHONE1<>'0' AND tb.FAXPHONE1<>'0'     

AND tb.VOICEPHONE2<>'0'  --62016          

        

SELECT @c1=@@ROWCOUNT               

              

              

BEGIN                    

                   

                    

 UPDATE ST                   

 SET Row_count=@c1              

 ,STARTTIME=@START_TIME                    

 ,ENDTIME=GETDATE()               

 FROM SOURCETABLES ST              

 WHERE DATASOURCEID=42  AND ST.Datasourcename='SRMS'  AND TABLENAME='Incident_Srms_Backlog' AND FieldName IN ('COMPANY1','VOICEPHONE1','ALTERNATEPHONE1','FAXPHONE1','VOICEPHONE2')          

          

END          

         

--We are updating  Redact value for ('CustomerEmail','ContactPhoneNumber','ContactPhoneNumber2','customer' for above Completion_date>90 days.        

SET @START_TIME =GETDATE();         

UPDATE WT                         

SET  WT.CustomerEmail='Redact'           

,WT.ContactPhoneNumber='0'          

,WT.ContactPhoneNumber2='0'          

,WT.customer='Redact'                              

FROM  W6TASKS  WT        

INNER JOIN [vw_UCAREPII_TXNS] Vw                          

ON WT.Callid = Vw.Incident_Number       

where VW.Datasourcename='CLICK' AND  WT.CustomerEmail<>'Redact' AND WT.ContactPhoneNumber='0'  AND WT.ContactPhoneNumber2<>'0' AND WT.customer<>'Redact'    --62016       

      

      

        

SELECT @c1=@@ROWCOUNT               

              

              

BEGIN                    

                                     

                    

 UPDATE ST                   

 SET Row_count=@c1              

 ,STARTTIME=@START_TIME                    

 ,ENDTIME=GETDATE()       

 FROM  SOURCETABLES ST              

 WHERE  TABLENAME='W6TASKS' AND ST.Datasourcename='CLICK'        

 AND FieldName IN ('CustomerEmail','ContactPhoneNumber','ContactPhoneNumber2','customer')             

            

             

END            

        

END; 

GO



Comments

Post a Comment

Popular posts from this blog

java chapter11 practice question on abstruct class and interfaces

  /* Chapter 11 - Practise Set 1... Create an abstract class Pen with methods Write () and refill 1) as abstract methods 2... Use the Pen Class from Q1 to create a Concrete class fountain Pen with additional method change Nibl) 3...Create a class Monkey with jump () and bitel) methods. Create a class Human which inherits this Monkey class and implements Basic Animalinterface with eati) and sleep methods. 4.... Greate a class Telephone with ring() liftus and disconnect ( methods as abstract methods Create another class Smart Telephone and demonstratepolymorphism 5.....Demonstrate polymorphism Msing monkey class from Quess 3. 6.......Create an Interface TV Remote and use it to inheritanother Interface Smart Tv Remote 7...... Create a Class Tv which implements Tv Remote interface qsn 6 */ package com.company ; //programe 1 abstract class Pen { abstract void Write (); abstract void Refill (); } //programe 2 class FountainPen extends Pen { void ...
Read more

DAY 12 -AZURE DP900(Microsoft Azure Data Fundamentals: Explore non-relational data in Azure)

Image
  Microsoft Azure Data Fundamentals: Explore non-relational data in Azure 1. Explore non-relational data offerings in Azure 2. Explore provisioning and deploying non-relational data services in Azure 3. Manage non-relational data stores in Azure Explore non-relational data offerings in Azure---------- Introduction Completed 100 XP 1 minute Data comes in all shapes and sizes, and can be used for a large number of purposes. Many organizations use relational databases to store this data. However, the relational model might not be the most appropriate schema. The structure of the data might be too varied to easily model as a set of relational tables. For example, the data might contain items such as video, audio, images, temporal information, large volumes of free text, encrypted information, or other types of data that aren't inherently relational. Additionally, the data processing requirements might not be best suited by attempting to convert this data into the relational format. In ...
Read more

java exercise4

  //implement a library using java class library //methods: issuebook,returnbook,showavailablebooks //properties:to store available books,store issued books //exercise 4 package com.company ; class library { String [] books ; int no_of_books ; library () { this . books = new String[ 100 ]; this . no_of_books = 0 ; } void addbook ( String book) { this . books [ no_of_books ] = book; no_of_books ++; System . out .println(book + ".... has been added....." ); } void showavailablebooks () { System . out .println( "available books are :" ); for ( String book : this . books ) { if ( book == null ) { //break;------//issue book jdi null hoye jy tale porer books shor krbe na tai continue continue ; } System . out .println( "*..." + book ); } } void issuebook ( String book) { //for (String b:th...
Read more