How to enter PTO(Time-Off) in Kronos for your Employee

 How to enter PTO in Kronos for your Employee 

Go To Manage Schedule-> Click on Full Schedule->Select employee->right click on day->Enter time-off

-> Click on Request Time of ->Click on Apply-> after that Enter Time off-> Review and submit.

To find if a particulate table column changed in SQL Server

 

SELECT
OBJECT_NAME(a.[object_id]) as [table_Name]
,a.[name] as [column_Name]
,b.modify_date
, b.create_date
FROM [sys].[columns] a
JOIN [sys].[objects] b
ON a.[object_id] = b.[object_id]
where OBJECT_NAME(a.[object_id])='F0911'
ORDER BY b.modify_date DESC

2 Digit Year in SQL Server

FORMAT(DATEADD(year, 1, getdate()), 'yy') 

-- In Select statement

Select FORMAT(DATEADD(year, 0, getdate()), 'yy')  from PRODDTA.F0010 where ccco='00000'

also you can add one year 

FORMAT(DATEADD(year, 1, getdate()), 'yy') 

Error: Must declare a named package eclipse because this compilation unit is associated to the named module

Fix:

Just delete module-info.java at your Project Explorer tab.

https://stackoverflow.com/questions/53033899/must-declare-a-named-package-eclipse-because-this-compilation-unit-is-associated

Convert Celsius in Fahrenheit Java Eclipse

 import java.util.Scanner;

public class h1 {

public static void main(String[] args) {

Scanner in = new Scanner( System.in );

System.out.print( "Enter a temperature in Celsius: ");

double celsius = in.nextDouble();

System.out.printf("The temperature is %,.2f in Fahrenheit.\n",

(9.0/5.0*celsius) + 32 );

}

}

Sum two numbers Java eclipse

 

public class h1 {

public static void main(String[] args) {

int firstNumber, secondNumber;

java.util.Scanner in = new java.util.Scanner( System.in );

firstNumber = in.nextInt ( );

secondNumber = in.nextInt ( );

System.out.println ( firstNumber + " + " + secondNumber +

" = " + (firstNumber+secondNumber) );

}

}

TripleInteger Java class

import java.util.Scanner;

public class TripleInteger {

public static void main(String[] args) {

// TODO Auto-generated method stub

Scanner in = new Scanner( java.lang.System.in );

int n = in.nextInt();

System.out.println( "The number " + n + " tripled is " + n*3 );

}

}

Re-indexing SQL Tables

 DBCC DBREINDEX ('TBL_VERGLDATA_DD', ' ', 70);  

DBCC DBREINDEX ('tblPP_TranData', ' ', 70);  

DBCC DBREINDEX ('tblAct_PP_TranData', ' ', 70);  

DBCC DBREINDEX ('tblPPTYPE', ' ', 70);