February 27, 2006
February 15, 2006
Also lowercase all capitalized words.
'MY NAME IS ROSHAN' --> 'My Name Is Roshan'.
Usage Select Capitalise('MY NAME IS ROSHAN')
CREATE FUNCTION Capitalise (@String VARCHAR(255))
RETURNS VARCHAR(255) AS
DECLARE @StringCount int
SET @string = LOWER(@string)
SET @string = STUFF(@string,1,1,LEFT(UPPER(@string),1)) --Capitalize
the first letter
SET @StringCount = 0
WHILE @StringCount < LEN(@string)
SET @string = STUFF(@string,CHARINDEX(SPACE(1),@string,@StringCount)+1,1,SUBSTRING(UPPER(@string),CHARINDEX(' ',@string,@StringCount)+1,1))
SET @StringCount = @StringCount + 1
February 14, 2006
Think a small number
Double this number
Add 8 to the result
Divide the result by 2
Subtract the original number
Convert this into a letter of the alphabet. (1=A, 2=B, 3=C, 4=D, 5=E etc.)
Think of the name of a country which starts with this letter.
Think of an animal whose name starts with the country's second letter.
hahaha You are wrong actually there is no elephants in Denmark except some in the zoo..
Thank you friends for not thinking about ostrich in Dominica. Still you don't think I mastered the art of telepathy, then try this
Think a 3-digit number where the first and last digits differ by 2 or more...
"reverse" number, obtained by reading it backwards.
Subtract the smaller of these two numbers from the larger one.
Add the result to its own reverse.
Is it 1089 ?
February 13, 2006
9-15 = 4-10
9-15+(25/4) = 4-10+(25/4 ) // adding 25/4 to both sides:
9+(25/4)-15 = 4+(25/4)-10 //Changing the order
//(this is just like : a square + b square - two a b = (a-b)square.)
//Here a = 3, b=5/2 for L.H.S and a =2, b=5/2 for R.H.S.
. ' . (3-5/2)(3-5/2) = (2-5/2)(2-5/2)
3 - 5/2 = 2 - 5/2 //Taking positive square root on both sides
3 = 2
February 02, 2006
Me: Hi, my name is Roshan, and I'll be your Support Waiter. What seems to be the problem?
Guest: There's a fly in my soup!
Me: Try again, maybe the fly won't be there this time.
Guest: No, it's still there.
Me: Maybe it's the way you're using the soup; try eating it with a fork instead.
Guest: Even when I use the fork, the fly is still there.
Me: Maybe the soup is incompatible with the bowl; what kind of bowl are you using?
Guest: A SOUP bowl!
Me: Hmmm, that should work. Maybe it's a configuration problem; how was the bowl set up?
Guest: You brought it to me on a saucer; what has that to do with the fly in my soup?!
Me: Can you remember everything you did before you noticed the fly in your soup?
Guest: I sat down and ordered the Soup of the Day!
Me: Have you considered upgrading to the latest Soup of the Day?
Guest: You have more than one Soup of the Day each day?
Me: Yes, the Soup of the Day is changed every hour.
Guest: Well, what is the Soup of the Day now?
Me: The current Soup of the Day is tomato.
Guest: Fine. Bring me the tomato soup, and the check. I'm running late now.
[Returns with another bowl of soup and the check]
Me: Here you are, Sir. The soup and your check.
Guest: This is potato soup.
Me: Yes, the tomato soup wasn't ready yet.
Guest: Well, I'm so hungry now, I'll eat anything.
after 10 minutes ......
Guest: Waiter! There's a gnat in my soup!
Soup of the Day . . . . . . . . . . . . . . . . . . $5.00
Upgrade to newer Soup of the Day. . $2.50
Access to support . . . . . . . . . . . . . . . . $1.00