Monthly Archives: June 2013

ILT – Simple technique to toggle between true and false or one and zero

20/06/2013 If you want to toggle a value from 1 to 0 or 0 to 1 depending on the current value then you are at the right place. (i.e. change the value to 0 only if it’s 1 now and … Continue reading

Posted in Algorithms & Concepts, General Computing | Tagged , , , , | Leave a comment

XSD validation for integer – How to allow empty values for integer while limiting value range (ILT)

19-06-2013 How to write XSD to validate an integer field so that only a range of values and empty tags are allowed. Example: I wanted to allow any value between -1 and 999 and also had to allow empty tags … Continue reading

Posted in Database-Concepts, General Computing | Tagged , , , , , , , , | Leave a comment

ILT – How to find if two time frames overlap or collide?

14/06/2013 Let’s assume that time frame 1 starts from Start1 and ends on End1 (Time Frame 1 = Start1 – End1) Similarly Time frame 2 = Start2 – End 2 Time Frame 1 and Frame 2 Over Lap IF: Start1 … Continue reading

Posted in Database-Concepts, General Computing, SQL Server | Tagged , , | Leave a comment