Category Archives: Uncategorized

Why Brackets in SQL queries with SQL Server

It’s been long time since I worked with SQL Server last time. I have been working with Oracle and there are differences for sure. This one is simple. The brackets are required if you use keywords or special chars in … Continue reading

Posted in Databases, MSSQL, Uncategorized | Tagged | Leave a comment

Top Screen Resolutions and Browsers

The top screen resolutions from Oct 2015 to Oct 2016 Last month with mobile devices included Top 5 browsers

Posted in Uncategorized | Leave a comment

Change color based on field value in Jaspersoft Studio

Change color based on field value in Jaspersoft Studio We may change the color, font size and style of the field value based on a condition. For example, we have two fields called $F{numberofissues} and $F{projectname}. We want to highlight … Continue reading

Posted in Jaspersoft Studio, Uncategorized | Tagged , , | Leave a comment

Floor, Ceiling and Rounding with MySQL

I was trying to get the average solution time of issues in Redmine per tracker type. In order to get the average time, I first selected creation time of issue and extracted it from the date of solution of the issue (this … Continue reading

Posted in MySQL, Uncategorized | Tagged , , , | Leave a comment

Convert all letters of many words to * (asterisk) except first letters

<!–[if gte mso 9]> <![endif]–> private string NameConvert(string name, string surname)         {             name = name.Trim();  //can be many names             surname = surname.Trim();      string wholeName = String.Format(“{0} {1}”, name, surname);             string[] nameArray = wholeName.Split();             for(int … Continue reading

Posted in Uncategorized | Leave a comment