Previously I blog about Pentaho and succesfully run it in my ubuntu 8.04 box. After a while, I upgrade my pc to ubuntu 8.10 and my pentaho is not working properly. I got below error while trying to create a new database connection.
org.pentaho.ui.xul.XulException:java.lang.NullPointer Exception
Solution for this error is pretty much easy but it take me [...]
Data migration is the process of importing legacy data to a new system. It is a routine part of IT operations in today’s business environment.
Common Data Migration Scenarios :
* Mergers and acquisitions
* Legacy system modernization
* Enterprise application consolidation, implementation, or upgrade, such as an SAP ERP or CRM implementation
* Master data management implementation
* Business process [...]
I don’t know if someone else want to know about this but hey, sharing is caring right.
Declare @dateTimeToWait as DATETIME
Set @dateTimeToWait = ‘2020-11-11 15:02:43.000 ‘
While (1=1)
BEGIN
IF getdate() > @dateTimeToWait Break
— Sleep for 30 seconds
WAITFOR DELAY ‘00:00:30′
END
– ADD YOUR SQL HERE
Print ‘your SQL query goes here’
Till then….adios.
This will me my reference of SQL statement. I will update this post if I find anything that I feel useful for me..and for you.
1. Check for temporary table and Drop table if exist.
IF object_id(’tempdb..#myTempTable’) IS NOT NULL drop table #myTempTable
2. Convert SQL string to HEX
select CONVERT(varbinary(100),’select getdate() as MyDateInHex’)
