ASS On Fire Takes You Higher

There is an existing looong SQL query which selects some products for a condition where Sub product like ‘ %Bill - Option% ’ Now as a part of an enhancement a request came from a user ( via email in Outlook ) to add a new Product with Sub Product Bill – Option   One of my team mates  worked on this and added the new product in a table.. Simple Enough..!! UAT Started and today the User came back saying that the new product is not being selected. I was called in for help and after breaking my head for 1 hour determined that the team mate who added the new product, copied the Sub Product name directly from the User’s Email and entered into the table. Now Microsoft Word on typing a - changes it to a slightly longer version of – . This is clearly visible here in Outlook but when you look at these two things in SQL. They look exactly the same. Example:  (The two above are different; one is a copy from Outlook the other typed).  One works, the other doesn’t  Can you gues

Trupti sat late on a Friday evening in the office. The office was empty as everyone had left on time except her. The office was dark and the only source of light was from her own monitor. She was stuck trying to debug a particular tricky piece of code.  This application called SRC had been handed over to her only 6 days ago and she had to remove 4 bugs from the application in a week.  Trupti was confident that should we able to tackle the issues very easily as she had done multiple times in the past and meet the dead lines comfortably. That was the reason that her supervisor had full faith in her talents and had handed this seemingly easy piece of work to her. This would be the 8th and final project which she would have to complete in 2011. But this application was proving to be a tricky one. Even after 6 days she was nowhere close to even re-producing the bugs. After 2 days when she had asked her supervisor if any documentation exists for the code, she was informed that non