Bad luck for the Fantasy Premier League Managers out there. Only 3 games to be played this week and keeping my fingers crossed for the Manchester City – Everton match. If there are any managers out there who have made more than one transfers this week, I can them banging their heads on the wall. My total this week – 12 and that too made an extra tranfer – Van der vaart 
sheesh! Click here to get tips and tricks
Fantasy Premier League News & Tips
December 19, 2010GRE Tips & Tricks
December 19, 2010Mugging up the 3,500 long word list can be a big pain especially when we come across words which would not seem relevant to our domain. Professionally I am a Senior Software Engineer and when I come across words like “Scuttle” which means “Sink”, I wonder who would actually say “My ship ‘scuttled’ “! or may be “We just ‘scuttled’ the enemy ship!” I wouldn’t go through the pain of actually mugging up such a word and then present it to a person who would only be seeing stars unless if he is some verbal scholar! I was trying to find out some solution to this. Click Here
Few Days of my Life
October 10, 201001.08.2006 – BM
10.10.2008 – BP *
29.11.2008 – BCr
10.12.2008 – BJa
14.12.2008 – B.CldSh
13.02.2009 – B.Prty[:),hrt,agr,:D]
24.05.2009 – B.Pht
14.06.2009 – ???
20.07.2009 – ____
05.02.2009 | 26.02.2009 – Sometimes even the smallest of gestures can give you a lot of joy……..
31.08.2009 – *
03.09.2009 – *
22.09.2009 – *
22.11.2009 to 27.11.2009 – *
01.12.2009 – Gift Rejected – The only gift I have presented to anyone outside my family.
06.10.2010 – Gift Opened but still rejected
Yossi Benayoun Signs with Chelsea
July 4, 2010Israel midfielder Yossi Benayoun signs a three year contract with Chelsea. “I am very excited to come to a club like Chelsea, it is a big club and I think it is a dream for every player. Hopefully we will be successful,” said the former Liverpool Midfielder.
Further details can be found at the following link.
http://www.chelseafc.com/page/LatestNews/0,,10268~2082180,00.html
VTU 8th Semester results announced – B.E/B.Tech
June 28, 2010Visvesvaraya Technological University Karnataka has declared the results of the final semester engineering and technology students. The students of the VTU who have appeared in the 8th semester examination of their bachelor of technology / bachelor of engineering degree can find their results online at the official weblink of the Visvesvaraya Technological University – http://results.vtu.ac.in/
Germany vs England World Cup 2010
June 28, 2010Well… What can I say! Thank You Fabio Capello! You seem to have made the English defence look like a mere sheet instead of a wall. Just look at the way Klose powers his way through Upson! Whose side is Glen Johnson on? All he wants to do is attack and no defence? Why was a player like Dawson overlooked when he had a brilliant season with Tottenham?!? And where was the ever so dependable John Terry??? The defence was a total failure!!! But one of the most shocking decisions did take place and that was disallowing Lampard’s clear goal? What was the referee doing? Looking at some female fan behind the goal! He must have snapped out of it when the German Keeper held the ball!!! Absolutely pathetic! FIFA refereeing standards are worse than the English Premier League’s!!! Where do they get these guys from? Ask me to be an assistant referree and I would be like a Maradona of Assistant Referees! I am sure atleast England’s attacking front would have done better had that goal been given! And Gareth Barry?!? Come on now! There is no point carrying an injury and jogging like a 60 year old! Come on if you want to show your Lion’s Heart you have to play like one too! Capello, there is only one person to blame and that is YOU!!! It never seemed like you had a plan for a highly attacking team! You should have done your homework!!! Guys what do you think! Comments appreciated!
Retrieving Unique Values from a DataTable in .NET
March 25, 2009The easiest way to return a new table that has only the unique values from the original table is as follows:
DataTable distinctTable = originalTable.DefaultView.ToTable(true, “FieldName”);
Thus “distinctTable” will contain unique values!!! 
Have fun!
Using Variables in T-SQL Statements that accept only constant values
December 31, 2008Developers usually come across a situation wherein they would want to use a variable in a T-SQL Statement which accepts only constant values.
For example, if we try to assign a variable to a Select Top <@variable_name> statement, we would get an error like:
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near ‘@variable_name’
There is a work around this problem though. The below stored procedure solves it:
CREATE PROCEDURE TEST
@TestInt INT
AS
BEGIN
DECLARE @SqlQuery NVARCHAR(4000);
SET @SqlQuery = ‘SELECT TOP ‘+CAST(@TestInt as CHAR)+’* FROM TABLE_TEST’;
EXEC(@SqlQuery)
END
Formatting DateTime in SQL Server
October 23, 2008As a Developer, you would come across a scenario where you would want SQL Server to return DateTime in a particular format to the front end. You can use SQL Server’s built in function GETDATE() to return the current DateTime. But if you need a universal date/time, use the built-in function GETUTCDATE(). SQL Server provides format numbers to format the date/time string returned. All you need to do is convert the specific date to a string and specify the format number corresponding to your required format.
Below is a list of few Date formats and their corresponding outputs:
| Date Formats | ||
|---|---|---|
| Format No. | SQL Query | Output |
| 1 | select convert(varchar, getdate(), 1) | 12/30/06 |
| 2 | select convert(varchar, getdate(), 2) | 06.12.30 |
| 3 | select convert(varchar, getdate(), 3) | 30/12/06 |
| 4 | select convert(varchar, getdate(), 4) | 30.12.06 |
| 5 | select convert(varchar, getdate(), 5) | 30-12-06 |
| 6 | select convert(varchar, getdate(), 6) | 30 Dec 06 |
| 7 | select convert(varchar, getdate(), 7) | Dec 30, 06 |
| 10 | select convert(varchar, getdate(), 10) | 12-30-06 |
| 11 | select convert(varchar, getdate(), 11) | 06/12/30 |
| 101 | select convert(varchar, getdate(), 101) | 12/30/2006 |
| 102 | select convert(varchar, getdate(), 102) | 2006.12.30 |
| 103 | select convert(varchar, getdate(), 103) | 30/12/2006 |
| 104 | select convert(varchar, getdate(), 104) | 30.12.2006 |
| 105 | select convert(varchar, getdate(), 105) | 30-12-2006 |
| 106 | select convert(varchar, getdate(), 106) | 30 Dec 2006 |
| 107 | select convert(varchar, getdate(), 107) | Dec 30, 2006 |
| 110 | select convert(varchar, getdate(), 110) | 12-30-2006 |
| 111 | select convert(varchar, getdate(), 111) | 2006/12/30 |
Below is a list of few Time formats and their corresponding outputs:
| Time Formats | ||
|---|---|---|
| Format No. | SQL Query | Output |
| 8 or 108 | select convert(varchar, getdate(), 8 ) | 00:38:54 |
| 9 or 109 | select convert(varchar, getdate(), 9) | Dec 30 2006 12:38:54:840AM |
| 14 or 114 | select convert(varchar, getdate(), 14) | 00:38:54:840 |
The Lone Wolf Will be back!
September 14, 2008Tried to post about my feelings for a very long time…. But always felt weak when my fingers got to type them…. One day when I feel I am strong enough for it…. I will POST….
