by admin | Jul 27, 2021 | Uncategorized
Example SQL statement SELECT * FROM OPENROWSET(‘Microsoft.ACE.OLEDB.16.0’, ‘Excel 12.0; Database=e:\excelimport\leadmaster.xlsx; HDR=YES; IMEX=1’, ‘SELECT * FROM [LeadMaster$]’); explanation: e:\excelimport\leadmaster.xlsx is the...
by admin | Jul 16, 2021 | Uncategorized
Recently I have bought a new PC with Ryzen 5800x with Geeek A31 Mini ITX case. The case is about 6Liter size, but it has good airflow compare to some other 5Liter mini ITX case. Below are the components for my mini ITX PC Low profile CPU cooler Noctua NH-L9a-AM4...
by admin | Jul 11, 2021 | Uncategorized
Nowadays we often deal a lot of JSON data, and array of data objects. What is the best way of filtering unique data of a data field/member property? With JavaScript latest ES6 and spread operator it can be done with just 1 line of javascript. var data=[] ; //sample...
by admin | Jul 17, 2019 | Uncategorized
Not just that we send customer personalized SMS to notify them their treatment redeemed and balance. But we also provide customer a link to rate their experience. This is an advance CRM function to further engage with customer and understand their experience.
by admin | Jul 5, 2019 | Uncategorized
Many years ago, when I am not so proficient in SQL, I often use programming language with complex loop and later with REGEX to extract 5 digits zip code from database. But when the advancement in technology , things can be pretty much easy. Just use PATINDEX in SQL...
by admin | Jun 18, 2019 | Uncategorized
Creating a new table Listing with pure HTML5 CSS + javascript. This will allow more flexible grid/table with re-sizable column. Upcoming we will have Sorting enable grid Filter enable grid Some features from Excel in terms of custom sorting and filtering Ultimately we...