Skip to main content

Posts

Showing posts from February, 2006

UDF For Capitalising First Letter in SQL Server 2000

This is a User Defined Function that will capitalize the first letter of a character after a space. 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 BEGIN 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) BEGIN IF SUBSTRING (@string, CHARINDEX ( SPACE (1),@string,@StringCount),1) = SPACE (1) BEGIN SET @string = STUFF (@string, CHARINDEX ( SPACE (1),@string,@StringCount)+1,1, SUBSTRING ( UPPER (@string), CHARINDEX (' ',@string,@StringCount)+1,1)) END SET @StringCount = @StringCount + 1 END RETURN @string END

me Telepathist ??

Hey believe me I can read your mind. 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 ?

3 = 2, am I right ?

-6 = -6 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 ----- ---

Joke

I am really fed up, for the last three months working in production support. Code drops, bug fixing and installation on daily basis. Seriously thinking about changing the job. I don't mind even if it is as a waitor in the hotel, but the fact is that I will be a failure in that too. Let us c Guest: Waiter! 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 d