sp.config load

 USE [DellPII]

GO


/****** Object:  StoredProcedure [dbo].[SP_ConfigLoad]    Script Date: 3/29/2022 10:38:25 AM ******/

SET ANSI_NULLS ON

GO


SET QUOTED_IDENTIFIER ON

GO


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

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

                

              

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

            

CREATE    PROCEDURE [dbo].[SP_ConfigLoad]                  

AS                    

BEGIN                   

                

  SELECT * FROM [DellPII].[dbo].[DataSecure]               

          

--INSERT INTO  [DellPII].[dbo].[DataSecure] values('Encryption',1,'UcareAdmin',GETDATE())             

--INSERT INTO  [DellPII].[dbo].[DataSecure] values('Redact',2,'UcareAdmin',GETDATE())   



select * from PIIClientChild


--insert into PIIClientChild (Clientid,ClientName,IsActive,LastUpdatedBy,LastModifiedDate,ClientParentID) Values('0043200131','EMC',1,'UcareAdmin',GETDATE(),3) 

--insert into PIIClientChild (Clientid,ClientName,IsActive,LastUpdatedBy,LastModifiedDate,ClientParentID) Values('0043203872','EMC DATA DOMAIN',1,'UcareAdmin',GETDATE(),3) 

--insert into PIIClientChild (Clientid,ClientName,IsActive,LastUpdatedBy,LastModifiedDate,ClientParentID) Values('0044100131','Dell',1,'UcareAdmin',GETDATE(),3) 

--insert into PIIClientChild (Clientid,ClientName,IsActive,LastUpdatedBy,LastModifiedDate,ClientParentID) Values('0044100162','Dell',1,'UcareAdmin',GETDATE(),3)

--insert into PIIClientChild (Clientid,ClientName,IsActive,LastUpdatedBy,LastModifiedDate,ClientParentID) Values('0044100730','Dell',1,'UcareAdmin',GETDATE(),3) 

--insert into PIIClientChild (Clientid,ClientName,IsActive,LastUpdatedBy,LastModifiedDate,ClientParentID) Values('0044200171','DELL CANADA',1,'UcareAdmin',GETDATE(),3) 

--insert into PIIClientChild (Clientid,ClientName,IsActive,LastUpdatedBy,LastModifiedDate,ClientParentID) Values('0045100371','Dell',1,'UcareAdmin',GETDATE(),3) 

--insert into PIIClientChild (Clientid,ClientName,IsActive,LastUpdatedBy,LastModifiedDate,ClientParentID) Values('0047201271','DELL/WEGMANS',1,'UcareAdmin',GETDATE(),3) 

              

  SELECT * FROM   [dbo].[DataSecure]          

--SELECT * FROM  [DellPII].[dbo].[PIIConfig]               

----INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Model Number',42,'SRMS',1,'UcareAdmin',GETDATE())              

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Serial Number',42,'SRMS',1,'UcareAdmin',GETDATE())             

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Customer Primary Name',42,'SRMS',1,'UcareAdmin',GETDATE())            

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Address Line1',42,'SRMS',1,'UcareAdmin',GETDATE())              

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Address Line2',42,'SRMS',1,'UcareAdmin',GETDATE())              

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Address Line3',42,'SRMS',1,'UcareAdmin',GETDATE())            

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Address Line4',42,'SRMS',1,'UcareAdmin',GETDATE())           

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('City',42,'SRMS',1,'UcareAdmin',GETDATE())              

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('State Code',42,'SRMS',1,'UcareAdmin',GETDATE())              

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Postal Code',42,'SRMS',1,'UcareAdmin',GETDATE())            

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Country Code',42,'SRMS',1,'UcareAdmin',GETDATE())            

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Primary Contact Name',42,'SRMS',2,'UcareAdmin',GETDATE())              

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Primary Contact Email ID',42,'SRMS',2,'UcareAdmin',GETDATE())              

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Primary Contact Phone',42,'SRMS',2,'UcareAdmin',GETDATE())            

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Secondary Phone Number',42,'SRMS',2,'UcareAdmin',GETDATE())            

--INSERT INTO  [DellPII].[dbo].[PIIConfig] values('Agent Report Description',42,'SRMS','','UcareAdmin',GETDATE())            

                

  SELECT * FROM  [DellPII].[dbo].[PIIConfig]    

    

  --insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('Agent Instructions','UcareAdmin',GETDATE(),1,0)  

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('CompanyName','UcareAdmin',GETDATE(),1,0)  

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('Contact Type','UcareAdmin',GETDATE(),1,0)  

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('ContactName','UcareAdmin',GETDATE(),1,0)  

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('Customer Alternate Name','UcareAdmin',GETDATE(),1,0)  

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('Customer Mood','UcareAdmin',GETDATE(),1,0)  

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('ENVIRONMENT','UcareAdmin',GETDATE(),1,0)  

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('Item Subclassification Code','UcareAdmin',GETDATE(),1,0)      

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('Operating System','UcareAdmin',GETDATE(),1,0)  

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('Diagnostic Information','UcareAdmin',GETDATE(),1,0)  

--insert into PIIConfig (Fieldname,LastUpdatedby,lastmodifieddate,CLIENTPARENTID,ISACTIVE) values ('Warranty Expiration Date','UcareAdmin',GETDATE(),1,0)  

  select * FROM  PIIConfig               

--  INSERT INTO  [DellPII].[dbo].[PIIDBConfig] values('ODS','Incident_SRMS_Specific','Reported_Style ',1,'UcareAdmin',GETDATE())              

--INSERT INTO  [DellPII].[dbo].[PIIDBConfig] values('ODS','Incident_SRMS_Attention','Vendor_Style',1,'UcareAdmin',GETDATE())   

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Serial Number','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Customer Primary Name','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Customer Alternate Name','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('City','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('State Code','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Postal Code','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Primary Contact Name','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Primary Contact Email ID','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Primary Contact Phone','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Secondary Phone Number','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Customer Mood','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('ContactName','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('CompanyName','UcareAdmin',GETDATE(),3,1,NULL)

--insert into PIIconfig (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID,ISActive,Comments) values ('Product Description','UcareAdmin',GETDATE(),3,1,NULL)




    

    

    

--1.Incident_SRMS_Specific --select * into Incident_SRMS_Specific  from [172.16.123.70].ods.dbo.Incident_SRMS_Specific WITH (NOLOCK)  --where Datasourceid=42 and National_Account_ID in('43200131') --155457      

  

--2.Incident_SRMS_Activity    

--insert into Incident_SRMS_Activity  --SELECT a.* --FROM [172.16.123.70].ods.dbo.Incident_SRMS_Activity A INNER JOIN [172.16.123.70].ods.dbo.Incident_SRMS_Specific B WITH (NOLOCK)  --on a.Incident_Number=b.Incident_Number and  a.Datasourceid=42  AND  B.National_Account_ID in('43200131') --285396    ----3.Incident_SRMS_TSDB --insert into Incident_SRMS_TSDB --SELECT a.* --FROM [172.16.123.70].ods.dbo.Incident_SRMS_TSDB A INNER JOIN [172.16.123.70].ods.dbo.Incident_SRMS_Specific B WITH (NOLOCK)  --on a.Incident_Number=b.Incident_Number and  a.Datasourceid=42  AND  B.National_Account_ID in('43200131')  ----1874319  (25 min)   

----4.Incident --insert into Incident --SELECT a.* --FROM [172.16.123.70].ods.dbo.Incident A INNER JOIN [172.16.123.70].ods.dbo.Incident_SRMS_Specific B WITH (NOLOCK)  --on a.Incident_Number=b.Incident_Number and  a.Datasourceid=42  AND  B.National_Account_ID in('43200131')    

--5.Incident_SRMS_Attention --insert into Incident_SRMS_Attention   

  

--SELECT a.* --FROM [172.16.123.70].ods.dbo.Incident_SRMS_Attention A WITH (NOLOCK)  INNER JOIN[172.16.123.70].ods.dbo.Incident_SRMS_Specific B WITH (NOLOCK)   

--on a.Incident_Number=b.Incident_Number and  a.Datasourceid=42  AND  B.National_Account_ID in('43200131')    

              

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