Friday, April 13, 2018

MySql Query to turn ON Query statistics I/O

SET STATISTICS IO ON
SET STATISTICS TIME ON
SELECT er.ReportID, er.ReportName, er.ReportNumber
FROM dbo.EmployeeReports er
WHERE er.ReportNumber LIKE '%33%'
SET STATISTICS IO OFF
SET STATISTICS TIME OFF

Read More...

MySQL Nested Case SQL statements (CASE WHEN OR THEN ELSE END )

Following is an example of nested MySQL Case When or then else End statement.
select
  CASE
  When (table.field1 = '01')
    THEN
      CASE
      When (SUBSTRING_INDEX(table.field1, ' ', 1) = 'abc')
         THEN '01abc'
         ELSE 'abc'
      END
  WHEN (table.field1 = '02')
    THEN
      CASE
      When ((SUBSTRING_INDEX(table.field1, ' ', 1)) = 'def')
        THEN '02def'
        ELSE 'def'
      END
  When (table.field1 = '03')
    THEN
      CASE
      When ((SUBSTRING_INDEX(table.field1, ' ', 1)) = 'efg')
        THEN '03efg'
      ELSE 'efg'
      END
  WHEN (table.field1 = '04')
    THEN
      CASE
      When ((SUBSTRING_INDEX(table.field1, ' ', 1)) = 'pqr')
        THEN '04pqr'
      ELSE 'pqr'
      END
  END
from table ;

Read More...

Tuesday, December 19, 2017

Is this the beginning of the end of BitCoin, Etherum and LiteCoin ? Did it really crashed today evening ??

The BitCoin was traded at $14,212 at 6:40 PM CST, December 19 2017. The price is almost 27% less than its highest value. At the time of the post of this blog, the BitCoin is now backed up to $17,149 

The Etherum was traded at $705 at 6:40 PM CST, December 19 2017. The price is almost 17% less than its highest value. At the time of the post of this blog, the Etherum is now backed up to $772 The

LiteCoin was traded at $277 at 6:40 PM CST, December 19 2017. The price is almost 37% less than its highest value of $371. At the time of the post of this blog, the LiteCoin is now backed up to $320 

Where as the Bitcoin Cash is enjoying a ride of $3100 per bitcoin cash which is almost 41% higher than its yesterday's price.

Read More...

Wednesday, August 30, 2017

Fix for xcrun: error: invalid active developer path after updating your mac OS to Sierra

If you are geting the following error with Git or any other tools while running it on from your terminal
 xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun. 

 using the following command to fix it
xcode-select --install

Read More...

Friday, March 3, 2017

Git Cheat Sheet

A. To List your local branchs :
  •   git branch

B. How to get or fetch a remote  Branch 
   You first need to fetch and check out the remote branc
  •    git fetch remote remote_branch_name (eg :  git fetch origin story2525/mytest_remote_branch)
  • git checkout remote_branch_name


C. How to delete a  Branch both locally and remotely:  

1. Delete the  remote branch   
  •   git push origin :branch_name or
  •   git push origin --delete branch_name

2. Delete a local branch
  •   git branch -d branch_name   (use -D if your branch hasn't been fully merge yet)         

D. How to rename your remote Branch : 

1. Rename branch locally
  • git branch -m old_branch new_branch

2. Delete the old remote branch   
  •   git push origin :old_branch            

3.  Push the new Branch  and update the upstream to point it to the new remote branch.
  •  git push --set-upstream origin new_branch
E. Git Logs :

git log --oneline | grep searchString
git log --pretty=format:"%cn committed %h on %cd"| grep searchString

F. Force Push :
 git push origin refactor/mybranch —force

G: Change the remote
git remote set-url origin <>




Read More...

Sunday, December 18, 2016

How to check if the given string is palindrome (Recursive vs Non-recursive )

palindrome is a word, phrase, number, or other sequence of characters which reads the same backward or forward, such as "level" or "kayak" or  "amanaplanacanalpanama" 

Following is the program to check if the given string is a palindrome.  



package com.mytech.today;


public class PalindromeClient {


    public static boolean isPalendrome (String s) {

        if(s== null) {
            throw new RuntimeException("null value passed");
        }

        int n = s.length();
        if(n==1) return true;
        else {

            for (int i=0; i < n/2 ; i++) {
                if(s.charAt(i)!=s.charAt(n-i-1)) {
                    return false;
                }
            }
        }
        return true;
    }

    public static boolean isPalendromeRecurrsive (String s) {

        if (s.length()<2) { return true;}
        else if (s.charAt(0)==s.charAt(s.length()-1)) {
            return isPalendrome(s.substring(1, s.length()-1));
        }
        else return false;

    }

    public static void main(String[] args) {
        System.out.println(isPalendrome("levvel"));
        System.out.println(isPalendrome("manaplanacanalpanama"));
        System.out.println(isPalendrome("a"));
        System.out.println(isPalendrome("jptt aefa afdaf"));

        System.out.println(isPalendromeRecurrsive("levvel"));
        System.out.println(isPalendromeRecurrsive("manaplanacanalpanama"));
        System.out.println(isPalendromeRecurrsive("a"));
        System.out.println(isPalendromeRecurrsive("jptt aefa afdaf"));
    }
}

Read More...

Wednesday, June 19, 2013

Replace Line Break and Spaces on Text Area using java script !

A simple way to replace line break and spaces on a text area content can be done simply by replacing the line break value and the space value with the corresponding html tag as following .

function replaceLineBreaksAndSpaces(textValue) {
   textValue = replaceSpaceCharacter(replaceLineBreak(textValue));
   return textValue;
}
   
function replaceLineBreak(textValue) {

    textValue = textValue.replace(/\r?\n/g, ' 
<br />');
    return textValue;

}

function replaceSpaceCharacter(textValue) {

    textValue = textValue.replace(/  /g, ' &nbsp;');
    return textValue;
}

Read More...

Pages

 ©mytechtoday.com 2006-2010

 ©Mytechtoday

TOP