Import MS Excel File into MSSQL using MS SQL Script
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 excel file path [LeadMaster$] is the...
Ryzen 5800x : how to reduce temperature?
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...
JavaScript: how to get Unique data from an array
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...
New Features: After Treatment Rating
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.
How to extract 5 digit zip Code/Post Code from address field
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...
New Table Listing
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...
Upcoming Changes ad addons
Revamp of appointment interface to support more dynamic appointment scheduling and also allow hotel booking and production scheduling style. That's why we are developing a totally new Gantt chart Duty Roster for work force scheduling. It is very important features for...
SVG Gantt Chart Development
Started development on multi purpose Gantt Chart. This Gantt chart will be used in job, appointment and also production resource scheduling later. The Gantt chart has more elements than any ordinary Gantt chart due to product...