Committees get overly complicated and bogged down. Here is a website that tries to solve this dilemma.
Irreverent but in an innovative way.
Reminds me of the book “Exploiting Chaos”.
Committees – Need Lots of Love and KISS
Reply
Monthly Archives: June 2012
Sybase SQL Question – Remove percentage sign from values in table
Solution:
If your DBMS does NOT have a “replace” function, you will have to use character substitution using several string functions.
Here is an example in Sybase and SQL Server.
UPDATE YourTable
SET YourColumn = stuff(YourColumn, patindex(YourColumn, ‘%’), 1, NULL)
This says find the pattern of ‘%’ in YourColumn. Now use that position number and replace aka stuff the character with NULL instead.
Good SQL, good night.
Redundant Fortune Cookies
Fortune cookies
Tom is having a nice lunch with his wife at a Chinese restaurant. At the end of the meal, they receive the traditional fortune cookies for two. Tom opens his cookie and reads the fortune. He realizes it is very similar to two or three other fortune cookies he has had recently. When the waiter comes by again, Tom asks, “If you receive the same fortune multiple times, does that mean it is more likely to come true?”
The waiter responds, “No, you eat lot of cookie.”
June Caption Contest
Here is my caption that I submitted to opinion.usatoday.com.
“I am trying to earn enough to move out by Independence Day or, my Mom says, there will be fireworks.”
The 7 most dangerous words in investing
An article about investing and stock picking that discusses the mind and how it plays tricks on you. It explains why you continue to invest in a stock that is going down.
http://blog.covestor.com/2012/06/the-7-most-dangerous-words-in-investing
Robosaurus
In terms of the future, there isn’t much need for Robosauraus, but it is really cool. Here is a video.
Three Envelopes
Stop me if you have heard this.
A newly hired manager moves into his new office and meets his predecessor on his last day. The predecessor tells the new manager there are three envelopes in the drawer and he is to use one each time a crisis occurs.
Well several months pass before a crisis happens. The manager goes to the drawer and gets the first envelope. He opens it. It says :”Blame the predecessor.” He does that and the crisis passes.
Several more months pass before another crisis happens. The manager again goes to the drawer and gets the second envelope. This time it says :Reorganize”. So he does that and the crisis subsides.
Again several more months pass and a third crisis happens. This time the manager goes to the drawer and knowing this is the last envelope, he hopes it contains the final solution he needs.
He opens the drawer and opens the last envelope. The contents say “Create three envelopes”.
SQL Question – Conditional Join on Columns based on value of one column
Here is my answer.
Try a union
select * from tbla ta, tblb tb
where ta.column_1 = 1
and ta.column_2 = tb.column_2
union
select * from tbla ta, tblb tb
where ta.column_1 = 2
and ta.column_2 = tb.column_2
and ta.column_3 = tb.column_3
union
select * from tbla ta, tblb tb
where ta.column_1 = 3
and ta.column_2 = tb.column_2
and ta.column_3 = tb.column_3
and ta.column_4 = tb.column_4
the end
Here is the website to see other answers
Needle.com and SQL Needler
Just read this article in USAToday regarding Needle.com an online customer service company that answers questions for various products.
http://www.usatoday.com/tech/columnist/talkingtech/story/2012-05-30/needle-talking-tech/55287900/1
I wonder if I should join the company and answer questions regarding SQL, Sybase, and database management. But the pay looks to be rather low.
Why Dinosaurs Are Extinct
For centuries, humans have wondered why dinosaurs were extinct.
In the last century scientists correlated the date a meteor collided with Earth with the approximate date the extinction occurred. They theorized that the Earth was covered with a thick dense cloud.
In the last several decades, archeologists have found evidence that the dinosaurs are actually descendants of birds.
I have a different theory that explains why dinosaurs are extinct. Dinosaurs tasted like chicken.
Michael E Kelley 