my note 5 fsm

 fsm>>>>


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Model Number','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Serial Number','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Item Subclassification Code','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Product Description','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Customer Primary Name','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Customer Alternate Name','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Address Line1','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Address Line2','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Address Line3','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Address Line4','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('City','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('State Code','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Postal Code','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Country Code','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Contact Type','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Primary Contact Name','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Primary Contact Email ID','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Primary Contact Phone','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Secondary Phone Number','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Agent Report Description','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Agent Instructions','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Warranty Expiration Date','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Customer Mood','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Operating System','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('Diagnostic Information','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('ENVIRONMENT','UcareAdmin',getdate(),'2')



insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('DIAGNOSTIC INFORMATION','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('ContactName','UcareAdmin',getdate(),'2')


insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID)

values('CompanyName','UcareAdmin',getdate(),'2')

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

INSERT INTO [dbo].[PIIConfig] 

(

            [DBName]

           ,[TableName]

           ,[FieldName]

           ,[FieldIdFK]

           ,[LastUpdatedBy]

           ,[LastModifiedDate]

           ,[SecureID]

           ,[ClientParentID]

)

  VALUES

  ('Model Number','UcareAdmin',getdate(),'2'),

  ('Serial Number','UcareAdmin',getdate(),'2') ,

  ('Item Subclassification Code','UcareAdmin',getdate(),'2'),

  ('Product Description','UcareAdmin',getdate(),'2'),

  ('Customer Primary Name','UcareAdmin',getdate(),'2') , 

  ('Customer Alternate Name','UcareAdmin',getdate(),'2'),

  ('Address Line1','UcareAdmin',getdate(),'2'),

  ('Address Line2','UcareAdmin',getdate(),'2'),

  ('Address Line3','UcareAdmin',getdate(),'2'),

  ('Address Line4','UcareAdmin',getdate(),'2'),

  ('City','UcareAdmin',getdate(),'2'),

  ('State Code','UcareAdmin',getdate(),'2'),

  ('Postal Code','UcareAdmin',getdate(),'2'),

  ('Country Code','UcareAdmin',getdate(),'2'),

  ('Contact Type','UcareAdmin',getdate(),'2'),

  ('Primary Contact Name','UcareAdmin',getdate(),'2'),

  ('Primary Contact Email ID','UcareAdmin',getdate(),'2'),

  ('Primary Contact Phone','UcareAdmin',getdate(),'2'),

  ('Secondary Phone Number','UcareAdmin',getdate(),'2'),

  ('Agent Report Description','UcareAdmin',getdate(),'2'),

  ('Agent Instructions','UcareAdmin',getdate(),'2'),

  ('Warranty Expiration Date','UcareAdmin',getdate(),'2'),

  ('Customer Mood','UcareAdmin',getdate(),'2'),

  ('Operating System','UcareAdmin',getdate(),'2'),

  ('Diagnostic Information','UcareAdmin',getdate(),'2'),

  ('ENVIRONMENT','UcareAdmin',getdate(),'2'),

  ('DIAGNOSTIC INFORMATION','UcareAdmin',getdate(),'2'),

  ('ContactName','UcareAdmin',getdate(),'2'),

  ('CompanyName','UcareAdmin',getdate(),'2');

  

  GO

  

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

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

####insert data using insert select query## INSERT INTO table2 (column1, column2, column3, ...) SELECT column1, column2, column3, ... FROM table1 WHERE condition; INSERT INTO [dbo].[PIIConfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) SELECT FieldName,LastUpdatedBy,getdate(),ClientParentID as 2 FROM [PIIConfig] where clientParentID =1



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


###value to value####


INSERT INTO [dbo].[PIIDBConfig]

    (       [DBName]

           ,[TableName]

           ,[FieldName]

           ,[FieldIdFK]

           ,[LastUpdatedBy]

           ,[LastModifiedDate]

           ,[SecureID]

           ,[ClientParentID]

           ,[ISActive]

           ,[PriColumnName]

    )

VALUES

    ('ods_sn_fsm','wm_task','dv_u_pcd_style','54','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','ITIL_Transaction','ProductName','54','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','Service_PCD_Style','54','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_serial_number','55','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','ITIL_Transaction','Categorization_Tier_1','55','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','Service_Serial_Number','55','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_bus_name','58','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_business_name','58','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_bus_name','59','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_business_name','59','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_street_address1','60','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_city','64','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','dv_u_time_zone','64','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','dv_u_locn_timezone','64','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','Service_Location_City','64','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','time_zone','64','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_zip_code','66','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','Service_Location_Zip','66','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_country','67','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','dv_u_country_value,','67','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','Service_Location_Country','67','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_contact','69','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_contact_phone','71','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_caller','71','UcareAdmin',getdate(),'2','2','1','NUMBER'),-----

('ods_sn_fsm','wm_task','u_caller_phone','71','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods','Task_FS_Mappings','Customer_Contact_Name','71','UcareAdmin',getdate(),'2','2','1','NUMBER'),----

('ods','Task_FS_Mappings','Customer_Contact_Phone1','71','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_alternate_contact_phone','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_caller_phone','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods','Task_FS_Mappings','Customer_Contact1_Phone1','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods','Task_FS_Mappings','Customer_Contact_Phone1','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_task','description','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','short_description','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','ITIL_Transaction','Description','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','ITIL_Transaction','Headline','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','short_description','73','UcareAdmin',getdate(),'1','2','1','NUMBER')

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

####field to field ####


INSERT INTO [dbo].[PIIDBConfig]

    (       [DBName]

           ,[TableName]

           ,[FieldName]

           ,[FieldIdFK]

           ,[LastUpdatedBy]

           ,[LastModifiedDate]

           ,[SecureID]

           ,[ClientParentID]

           ,[ISActive]

           ,[PriColumnName]

    )

VALUES

    ('ods_sn_fsm','wm_order','dv_u_pcd_style','54','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','ITIL_Transaction','ProductName','54','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_serial_number','55','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_parts_eta','56','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_parts_triage','56','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','description','57','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','ITIL_Transaction','Description','57','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','sys_user_group','DESCRIPTION','57','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','SUPPORTGROUP','DESCRIPTION','57','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_contact','58','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_bus_name','58','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_alt_contact','59','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods_sn_fsm','wm_task','u_street_address1','60','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','Service_Location_Address1','60','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods_sn_fsm','wm_order','dv_location','60','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_street_address1','60','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_street_address2','61','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_street_address2','61','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_city','64','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','Service_Location_City','64','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','dv_u_time_zone','64','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_city','64','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    

('ods_sn_fsm','wm_task','dv_state','65','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','dv_u_state ','65','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods','Task_FS_Mappings','Service_Location_State','65','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods','Task','STATUS','65','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods_sn_fsm','wm_order','dv_u_state','65','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','dv_state','65','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods','WORK_ORDER','Status','65','UcareAdmin',getdate(),'1','2','1','NUMBER'),


    ('ods_sn_fsm','wm_order','u_zip_code','66','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_country_value','67','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','Task_FS_Mappings','Service_Location_Country','67','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods_sn_fsm','wm_order','dv_u_country_value','67','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_country','67','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods_sn_fsm','wm_task','contact_type','68','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','wm_order','contact_type','68','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_order','dv_contact_type','68','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','wm_task','u_contact','69','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','wm_order','u_contact','69','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_alternate_contact_email','70','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','wm_order','u_alt_contact_email','70','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_contact_email','70','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_contact_phone','71','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_task','u_alt_contact_phone','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','wm_task','u_caller_phone2','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','wm_task','u_alternate_contact_phone','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','wm_task','u_alternate_contact_phone2','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods','Task_FS_Mappings','Customer_Contact_Phone2','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods','Task_FS_Mappings','Customer_Contact1_Phone1','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods','Task_FS_Mappings','Customer_Contact1_Phone2','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_alt_contact','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','wm_order','u_alt_contact_phone','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_alternate_contact_phone2','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_order','u_caller_phone2','72','UcareAdmin',getdate(),'2','2','1','NUMBER'),



    ('ods_sn_fsm','wm_task','CLOSE_NOTES','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods_sn_fsm','wm_task','u_interim_update_history','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods','Task_FS_Mappings','close_notes','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods_sn_fsm','wm_order','short_description','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),

('ods','sys_user_group','SHORT_DESCRIPTION','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),

    ('ods','SUPPORTGROUP','SHORT_DESCRIPTION','73','UcareAdmin',getdate(),'1','2','1','NUMBER'),


   ('ods_sn_fsm','wm_task','dv_u_processor_family','77','UcareAdmin',getdate(),'1','2','1','NUMBER'),


    ('ods_sn_fsm','wm_task,'company','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_task,'DV_COMPANY','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods','ITIL_Transaction','Company_SK','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','wm_order,'dv_company','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_order,'company','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods_sn_fsm','wm_order','company','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),

('ods','ITIL_Transaction','company_id','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods','ITIL_Transaction','Company_SK','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods_sn_fsm','sys_user','dv_Company','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),

    ('ods','SUPPORTGROUP','Company','82','UcareAdmin',getdate(),'2','2','1','NUMBER'),









     



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


https://unisyscorpeur-my.sharepoint.com/:v:/g/personal/darius_butkevicius_unisys_com/EbnksnQw4bpAjkpiggEwsWsB9k5Yw9AAf-s1Om0m1DwVqQ




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 Writ
Read more

java practice set 8

  questions: /* 1. Create a class Employee with the following properties and methods: Salary (property) (int) getSalary (method returning int) name (property) (String) getName (method returning String) setName (method changing name) 2. Create a class cellphone with methods to print “ringing…”, “vibrating…”, etc. 3. Create a class Square with a method to initialize its side, calculating area, perimeter etc. 4. Create a class Rectangle & problem 3. 5. Create a class TommyVecetti for Rockstar Games capable of hitting (print hitting…), running, firing, etc. 6. Repeat problem 4 for a circle. */ answers package com.company; class Employee{ int salary; String name; public int getSalary(){ return salary; } public String getName(){ return name; } public void setName(String n){ name = n; } } class CellPhone{ public void ring(){ System.out.print
Read more

new stored procidure with interval and frequery code

 CREATE procedure  [dbo].[SP_Baxter_CSAT]                                                                                                             AS                                                            BEGIN            DECLARE @ExtractIdOut INT                                                                   DECLARE @EndDt DATETIME2                                 DECLARE @runDate DATETIME2                                 DECLARE @RecordCount INT = 0                                                                 DECLARE @ProcedureName SYSNAME = OBJECT_NAME(@@PROCID)                                              DECLARE @intErrorCode INT                                                                 Declare @returnCode int = 0                                                                 DECLARE @ExtractProcessControlId UniqueIdentifier                                                                 SET NOCOUNT ON;                              BEGIN TRY           --Log the
Read more