And now they are telling How to Get Romantic

If all those reality shows were not enough, we have got a new one. And this one by far is the wierdest. There is this famous channel which has come up with this concept of arranged-come-love marriages. They have stuffed a household with 5 would be grooms and 10 women trying hard to be their eye candy. And then there are the usual confrontations. The ladies figthing over these guys.

Someone needs to tell these ppl, we have had enough of reality shows and we r not buying atleast this... i mean come on.. this is just too much man...

Find out what colums of a rows have null values - SQL Server

Ever wondered if u cud find out what columns of a row (of a table) have null values. This might help

DECLARE @Table TABLE
(
Id INT IDENTITY(1, 1),
FieldName VARCHAR(100)
)

INSERT INTO @Table (FieldName)
SELECT Column_Name FROM Information_Schema.Columns
WHERE Table_Name = 'Users'
AND Column_Name IN ('Zip', 'Phone', 'DateOfBirth')

CREATE TABLE #Values
(
FieldName VARCHAR(200),
FieldValue VARCHAR(200)
)

DECLARE @RowCount INT, @iLoop INT
DECLARE @FieldName VARCHAR(200)

SET @iLoop = 1
SELECT @RowCount = Count(*) FROM @Table

WHILE (@iLoop <= @RowCount)

BEGIN

SELECT @FieldName = FieldName FROM @Table WHERE Id = @iLoop

EXEC ('INSERT INTO #Values SELECT ''' + @FieldName + ''', ' + @FieldName + ' FROM Users WHERE UserKey = 4')

SET @iLoop = @iLoop + 1

END

SELECT * FROM #Values WHERE FieldValue IS NULL

-- SELECT * FROM #Values WHERE FieldValue IS NOT NULL AND FieldValue <> ''

DROP TABLE #Values

Love Aaj Kal - Ajj Din Chadheya

Ajj Din Chadheya
Tere Rang Warga
Ajj Din Chadheya
Tere Rang Warga

Phul Sa Hai Khila Aaj Din
Rabba Mere Din Yeh Na Dhale
Woh Jo Mujhe Khawab Mein Mile
Use Tu Lagede Abb Gale
Tenu Dil Da Vasta

Rabba Aaya Dar De Yaar De
Sara Jahan Chod Chad Ke

Mere Sapne Sawar De
Tennu Dil Da Vasta

Ajj Din Chadheya
Tere Rang Warga

Baksha Gunaho Ko
Sun Ke Duwao Ko
Rabba Pyaar Hai
Tune Sab Ko Hi De Diya

Meri Bhi Aahon Ko
Sun Le Duwao Ko
Mujhko Woh Dila Mene Jisko Hai Dil Diya
Hoooo

Baksha Gunaho Ko
Sun Ke Duwao Ko
Rabba Pyaar Hai
Tune Sab Ko Hi De Diya

Meri Bhi Aahon Ko
Sun Le Duwao Ko
Mujhko Woh Dila Mene Jisko Hai Dil Diya

Aasmaan Pe Aasmaan Uske De Itna Bata
Woh Jo Mujhko Dekh Ke Hase
Pana Chahun Raat Din Jise

Rabba Mere Naam Kar Use
Tenu Dil Da Vasta

Ajj Din Chadheya
Tere Rang Warga

Manga Jo Mera Hai
Jata Kya Tera Hai
Mene Kaun Si
Tujhse Jannat Manga Li

Kaisa Khuda Hai Tu
Bas Naam Ka Hai Tu

Rabba Jo Teri Itni Si Bhi Na Chali

Haaanaaa

Manga Jo Mera Hai
Jata Kya Tera Hai
Mene Kaun Si
Tujhse Jannat Manga Li

Kaisa Khuda Hai Tu
Bas Naam Ka Hai Tu

Rabba Jo Teri Itni Si Bhi Na Chali

Chahiye Jo Mujhe
Kar De Tu Mujhko Ata

Jeeti Rahi Saltanat Teri
Jeeti Rahe Ashiqui Meri

Dede Mujhe Zindagi Meri
Tenu Dil Da Vasta

Rabba Mere Din Yeh Na Dhale
Woh Jo Mujhe Khawab Mein Mile
Use Tu Lagede Abb Gale
Tenu Dil Da Vasta

Rabba Aaya Dar De Yaar De
Sara Jahan Chod Chad Ke

Mere Sapne Sawar De
Tennu Dil Da Vasta

Ajj Din Chadheya
Tere Rang Warga

Ajj Din Chadheya
Tere Rang Warga

Ajj Din Chadheya
Tere Rang Warga

Din Chadheya

Tere Rang Warga

Ajj Din Chadheya

Raat ke Dhai Baaje - One Awesome Song

Raat Ke Dhaai Baje Koi Shehnai Baje
Dil Ka Baazaar Laga Dhela Tak Paai Baze
LyricSMAsti.com
Raat Ke Dhaai Baje Koi Shehnai Baje
Dil Ka Baazaar Laga Dhela Tak Paai Baze

Chauke Chauke Chauke Se Khoye Khoye Se Hum
Aankhein Dubi Dubi Si Soye Soye Se Hum
Dil Ne Kaisi Durgat Ki Hai
Pehli Baar Mohabbat Ki Hai
Aji Aakhari Baar Mohabbat Ki Hai
Are Pehli Baar Mohabbat Ki Hai
Aakhari Baar Mohabbat Ki Hai

Jaan Hateli Upar Leli Jaanu Kaisi Harkat Ki Hai
Aji Pehli Baar Mohabbat Ki Hai
Aakhari Baar Mohabbat Ki Hai

Ishq Mein Chalate Hue Saans Tezaabi Lage
Raaj Khulata Hi Nahi Koi Toh Chaabi Lage

Ishq Mein Chalate Hue Saans Tezaabi Lage
Raaj Khulata Hi Nahi Koi Toh Chaabi Lage

Ishq Mein Chalate Hue Saans Tezaabi Lage
Saans Tezaabi Lage Ishq Mein Chalate Hue

Ho Chikne Chikne Lachchhe Hai Reshami Se Fande
Chupadi Chupadi Baaton Mein Bhole Bhaale Bande
Tanhaayi Mein Fursat Di Hai

Are Pehli Baar Mohabbat Ki Hai Thats Rite
Aji Aakhari Baar Mohabbat Ki Hai
Are Pehli Baar Mohabbat Ki Hai Hai
O Aakhari Baar Mohabbat Ki Hai

Raat Kuch Aisa Hua Jaisa Hota To Nahi
Thaam Ke Rakha Mujhe Main Bhi Khota To Nahi
Ek Hi Lat Suljhaane Mein Saari Raat Gujaari
Jaan Ki Gathari Sar Pe Le Li
Aapne Kaisi Jehmat Di Hai

Are Pehli Baar Mohabbat Ki Hai
Aji Aakhari Baar Mohabbat Ki Hai
Pehli Baar Mohabbat Ki Hai

Yeh Dooriyan - Lyrics

Yeh dooriyan
Yeh dooriyan
Yeh dooriyan

In raahon ki dooriyan
Nigahon ki dooriyan
Hum rahon ki dooriyan
Fanah ho sabhi dooriyan

Kyun koi paas hai
Door hai Kyun koi
Jaane Na koi yahan pe

Aa Raha paas ya door mein ja raha
Janu na mein hoon kahan pe

Yeh dooriyan

In raahon ki dooriyan
Nigahon ki dooriyan
Hum rahon ki dooriyan
Fanah ho sabhi dooriyan

Yeh dooriyan
Yeh dooriyan

Kabhi hua yeh bhi
Khali Rahon pe bhi
Tu tha mere saath

Kabhi tujhe milke lauta
mera dil yeh khali khali haath
Yeh bhi hua kabhi
Jaise hua Aabhi
Tujhko sabhi mein paa li
Tera mujhe kar jaati hain dooriyan
Satati hain dooriyan
Tarsati hain dooriyan
Fanah ho sabhi dooriyan

Kaha bhi na mene
Nahi jeena mene
Tu jo na mila

Tujhe bhule se bhi na
Bola na mene chahun fasla

Bas fasla rahein
Ban ke kasak jo kahen
Ho aur chahat yeh aur jawan

Teri meri mit jaani hai dooriyan
Begani hai dooriyan

Hat jani dooriyan
Fanah ho sabhi dooriyan

Kyun koi paas hai
Door hai Kyun koi
Jaane Na koi yahan pe

Aa Raha paas ya door mein ja raha
Janu na mein hoon kahan pe

Yeh dooriyan

In raahon ki dooriyan
Nigahon ki dooriyan
Hum rahon ki dooriyan
Fanah ho sabhi dooriyan

Tune Jo Na Kaha - New York... Best Song of the Year

Tune jo na kaha main wo sunta raha
khaamkha bewajah khwaab bunta raha
tune jo na kaha main wo sunta raha
khaamkha bewajah khwaab bunta raha

jaane kis ki hamein lag gayi hai nazar
is shehar mein na apna thikana raha
door chaahat se main apni chalta raha
khaamkha bewajah khwaab bunta raha

Dard wo pehle se hai zyaada khud se phir ye kiya vaada
khamosh nazrein rahe be zubaan
baaton mein pehle si baatein hai bolo to lab thartharate hai
raaz ye dil ka na ho bayaan
ho gaya ke asar koi hum pe nahi
hum safar mein to hai humsafar hai nahi
door jaata raha paas aata raha
khaamkha bewajah khwaab bunta raha

aaya wo phir nazar aise baat chidne lagi phir se
aankho mein chubhta kal ka dhuan
haal tera na hum sa hai kis khushi mein
kyun ghum sa hi basne laga kyun
phir wo jahan
wo jahan door jisse gaye the nikal
phir se yaadon ne kar di hai jaise pehal
lamha beeta hua dil dhukhaata raha
khaamkha bewajah khwaab bunta raha

tune jo na kaha main wo sunta raha
khaamkha bewajah khwaab bunta raha
jaane kis ki humein lag gayi hai nazar
is shehar mein na apna thikana raha
door chaahat se main apni chalta raha
bujh gayi aag thi daag jalta raha

Sung By - Mohit Chauhan

New York - Most Probably the Year's best

Watched New York today and think it is a job well done. Katrina Kaif is really looking very beautiful both as a college student and as a Wife. She has delivered some scenes really convincingly. Neil Nitin Mukesh is as always good. And John plays just right to be the anti-hero.

Songs are really good especially Junoon by K. K. and Tune Jo Na Kaha. I can safely say Tune Jo Na Kaha is on the top of my fav list at this point.

Its almost 2 hours now that I have finished watching the movie but the effect is still there. Really loved this movie. 3 cheers for Yash Raj and Kabir Khan for such a good job.

Radio City Crash

Hi I got this good looking ASP.NET error screen when I choose New Delhi at www.radiocity.in.
Looks they missed a trick there.

Khaamoshi achchi nahi

Khaamoshi achchi nahi inkaar hona chaahiyay
Yeh tamaasha ab sar-e-bazaar hona chaahiyay

Khaab ki ta'beer per israar hay jinko abhi
Pehlay unko khaab say baidaar hona chaahiyay

Ab wohi karnay lagay deedaar say aagay ki baat
Jo kabhi kahtay thay bus deedaar hona chaahiyay

Baat poori hay, adhoori chaahiyay a'e jaan-e-jaan
Kaam aasaan hay isay dushwaar hona chaahiyay

Dosti kay naam per kijiyay na kyun kar dushmani
Kuch na kuch aakHir tariq-e-kaar hona chaahiyay

Jhoot bola hay to kaayam bhi raho us per Zafar
Aadami ko saahib-e-kirdaar hona chaahiyay

Main Kudha Rehta hoon

Main aapnay gussay pe fida rehta hoon
Main zamaanay se khafa rehta hoon
Mujhse milna hai toh tanhai mein mil
Main akele mein kudha rehta hoon

Koi Baat Nahi

Yeh wafa ka silaa hai toh koi baat
Yeh dard tumnay diya hai to koi baat nahi

Yehi bahut hai ki tum dekhaty ho sahil se
Safina doob raha hai to koi baat nahi

Rakha tha aashiyana-e-dil main chhupa ke tumko
Woh ghar tumne chhod diya hai to koi baat nahi

Tum hi ne aayeena-e-dil mera banaya tha
Tum hi ne tod diya hai to koi baat nahi

Kiski majaal kahe koi mujh ko deewana
Agar yeh tumne kaha hai to koi baat nahi

Design Patterns - New course :(

No I have not joined college back nor am I talking about some new certification introduced by Microsoft. I am talking about a course run by my office called "Design Patterns". My office has started this university concept where we need to undertake new courses being introduced. In the process we need to complete certain assignments and finally take up 1 big exam. What will this earn us - some credits and a chance to get a promotion. In fact, this is the only way that we can get a promotion.

And now, we are presented with this new course on the Design Patterns. The course had started 2 weeks back and I have not even started looking at the course material. I just happen to know that we need to complete and submit a single assignment that is composed of 3 design patterns which a brief about our choice for the patterns.

Looks like this will be a long weekend for poor me. :(

My latest assignment - Silverlight 2.0

I was working on this new module I have been assigned in office when I came across Silverlight. Actually, I had to convert a WPF application into silverlight. The straight forward reason being - if it is on the web it is accessible from every where.

The conversion was not a straight forward one as Silverlight differs from WPF in a lot of ways. It supports a lot of things differently then WPF - backround images, brushes, control templates etc.

Silverlight can be made to run on any browser that has the Silverlight plugin installed - its 4.8 MB. Actually, the plugin is nothing but a mini CLR. Just as in Java, to run applets u needed JRE, in .NET to run Silverlight u need Silverlight plugin.

Silverlight applications are actually downloaded on the client and are actually run from the client machine only. Therefore, every user is actually running his own copy of the application. This brings Silverlight application quite close to windows programming with the difference that it runs in a browser.

There is not a lot of help about Silverlight on the net but http://www.silverlight.net can help u figure out answers to common programming tasks.

One more thing worth mentioning here is the WebClient class that helps u to receive response from a Uri. I leave it up to u guys to explore it in more details. However, it was something I required to get my job done :).

I m really satisfied things have come out and look to present it to my boss on Monday morning.

Cheers

UPA all the WAY!!

The verdict is out - its UPA (United Progressive Alliance) that has secured the majority in the Lok Sabha Elections 2009. In a much anticipated end to the election process that took place in 5 phases it was the UPA that had came out triumphant leaving the NDA (National Democratic Alliance) in dismay. The NDA surely needs to go back to drawing board to plan out their strategy while they still in the opposition for a straight 2ND time.

As far as I can remember, BJP/NDA really came into the big picture when Mr. Atal Bihari Vajpai formed a coalation government. Actually, it was then that the NDA was born. That government was actually could not complete its term.

Since then it has been Congress all the way. They romped in Sonia Gandhi which really provided them a boost and result was a Congress lead UPA government. Mrs. Gandhi clearly the differece this time around between the 2 sides and emerged as a National level leader.

I believe, this time too Congress had a clear picture about what they wanted to do. They brought Rahul Gandhi into the picture and started projecting him as the future. Gandhi junior was soon joined in by his sister Priyanka too. Rahul made it clear that he impress himself upon the nation as its future leader and also try and become popular among the youth. And now it can be safely said that the strategy has paid off.

On the other hand, after Mr. Atal Bihari Vajpai, BJP could never find National level leader who they can project as Prime Minister. BJP chief, Mr. Adavni is not really famous and that is not a secret. He is viewed as a hard-nosed politician who puts Hinduism before everything else. BJP had some able leaders and it is hard to figure out where they have disappeared. Call it a lackluster policy or a power game inside BJP itself, leaders like Mrs. Sushma Swaraj could never come up to the level they were capable off.

Anyways, for the time being, in fact for the next 5 years it looks to be UPA.

Jub sawan mein tanha bhegoge

Jub sawan mein tanha bhegoge
Jub aangan ko suna paoge
Jub sahil se takrati lehron mein
Tum door kahin kho jaaogay
Jub khud se baatein karte-2
Tum aapni tanhai meon kho jaaogay
Aur dil ki baat chupane ko
Tum humse nazar churaogay
Jub raat ke tanha damaan mein
Tum chand ko aadha paaogay
Main tum se mohabat karta hoon
Har bar yeh sunna chahogay
Un sab lamhon mein jaan lena
Ki tum tum nahi, hum banjaogay

Masoom mohabat ka itna sa fasana hai

Masoom mohabat ka itna sa fasana hai
Kagaz ki haveli hai barish ka zamana hai

Kya shart-e-mohabat hai, kya shart-e-zamana hai
Awaaz bhi zakhmi hai aur geet bhi gana hai

Us par utarne ki umeed bahut kum hai
Kashti bhi purani hai tofaan ko bhi aana hai

Woh samjhe ya na samjhe andaaz mohabaat ke
Ek shaks ko aankhon se ek sher sunana hai

Bholi si ada koi phir ishq ki had pur hai
Phir aag ka daria hai, phir doob ke jana hai

My Favorite Quotes!!

1. Of all the THINGS I have LOST, I MISS mu MIND the MOST.

2. When my GIRLFRIEND asked me she is seeing another GUY, I told her to RUB her EYES.

3. Multitasking - SCREWING several THINGS at ONCE.

4. The ATTRACTION in a PERSON is always the PERSONALITY.

5. The BEST way to get RID of TEMPTATION is to YIELD to it.

6. Smile, its the 2nd BEST thing u can do with ur LIPS.

7. SAVE EARTH! it is the only planet with GIRLS.

8. Girls are luckier than GUYS. If they cannot get something by being SMART, they get it by being DUMB.

9. Warning: Dates in calendar are closer than they appear...

10. If everything comes ur WAY, u r in the WRONG LANE!

11. In a FIGHT hit FIRST and hit HARD.

12. I was born fine, education ruined me.

13. When the GOING gets TOUGH, GREAT ones PARTY!

14. Shoot for the STARS, then U will perhaps reach the MOON.

15. Every time u FALL down u get UP to become STRONGER.

16. U miss 100% of the SHOTS u don't take.

More Coming!!

Finally a own a Laptop

Yes, I finally have bought a laptop and I am putting this entry using that only. Its been a long time since I have been thinking about buying a laptop. And this April, I decided to finally go for 1. I am very happy that I have finally bought it. And there are so many things that I am planning to do with it.

This is also going to make sure that I put in my blog entrier regularly. 3 cheers for my new laptop.

Koi Dewana Kehta Hai - by Dr. Kumar Vishwas

Koi deewana kehta hain koi pagal samjhta hai,
magar dharti ki bechaini ko bas badal samjhta hai,

Main tujhse dur kaisa hu,tu mujhse dur kaisi hai,
Yeh tera dil samjhta hai ya mera dil samjhta hai

mohobbat ek ehsason ki paawan si kahaani hai,
kabhi kabira deewana tha kabhi meera diwaani hai,

Yahaan sab log kehte hain meri aakho mein aansu hai,
Jo tu samjhe toh moti hain jo na samjhe to paani hai

Bahut bikhra bahut toota thapede seh nahi paaya,
Hawaaon ke ishaaron par magar main beh nahi paaya,

Adhoora an suna hi reh gaya youn pyaar ka kissa,
Kabhi tum sun nahi paaye, kabhi main keh nahin paaya

Bhramar koi kumudni par machal baitha toh hungama,
Humare dil mein koi khwaab pal baitha toh hungama,

Abhi tak doob kar sunte the sab kissa mohobbat ka,
Main kisse ko hakikat mein badal baitha toh hungama

Main uska hun wo is ehsaas se inkaar karta hai,
Bhari mehfil mein bhi ruswaa har baar karta hai,

yaki hai saari duniya ko khafa hai humse woh lekin,
Mujhe maaloom hai phir bhi mujhi se pyaar karta hai

Main jab bhi tez chalta hoon nazaare choot jate hain,
Koi jab roop gadhta hoon to saanche toot jate hain,

Main rota hoon to aakar log kandha thap thapate hain,
Main hasta hoon to mujhse log aksar rooth jate hain

Mat poooch ki kya haal hai mera tere aage,
Tu dekh ke kya rang hain tera mere aage

Samandar peer ka andar hain lekin ro nahi sakta,
Yeh aasu pyaar ka moti hain isko kho nahi sakta,

Meri chahat ko dulhan tu bana lena magar sun le,
Jo mera ho nahi paaya woh tera ho nahi sakta

sazi hai khushnuma mehfil sabhi dildaar bethe hain
jidhar dekho udhar hi ishq ke bimar bethe hain

hanseeno ki adaon pe sabhi dil haar bethe hain
hazaron mar-mite aur sekron tayaar bethe hain

After 6 long Years!!

After 6 years

OK, folks a bit of history for every one's benefit. Like all educated men, I also had the opportunity to attend a school when I was young. My school years had not really been eventful as I was more focused on my studies. But 2001-2002 was a different year. And this was the year that changed me in more than a few ways. This was the year I first fell in love with a girl. We use to meet at our tutions and that was where I got to know her. When, it was my final day of tution before the big board exams and I knew this may be the last time I'll be able to see her, I proposed her. And she refused. Well, folks it has been 6 years since that day and I had not seen her. We have been in touch via phone/ emails/ chats for the last 2-3 years, since I re-discovered her on the Internet. One big thanks to ORKUT for that.

I had asked her a few times to meet up but she never entertained the idea. And after trying a few times, even I had given up any hopes of meeting her again. But 06 May 2009 was a different day. I was returning home from my day job with my office colleague in my office cab when the idea of having a chicken roll hit one of us. We left the cab around Venkateshwara college and headed straight to one of the famous Roll shops in Satya Niketan.

As, I was just standing at the shop, chit-chatting with my colleagues, a familiar face passed by. I instantly knew it was her. She went into a shop. I could not resist, picked up my phone and called her. She acknowledged and came around to say "Hi". We had a brief chat wherein she did not miss to mention that I have put on a lot of weight. And then she had to move as her car-pool buddy was waiting for her.

Surprisingly, I did not feel the attraction I use to feel when I was in school. And frankly, she was not looking like anything she use to look like. Maybe it was just infatuation then. I did not feel anything for her. I even mentioned this to her the next day we had a chat. I know that was mean from my side but could not help it, it is in nature to be outspoken and a bit blunt at times.

All said and done, know I now she was not meant for me and and I thanked god and more importantly her for not letting me have her when I had a chance.

Therefore, 2 things are clear. First, I am still single and Second, I am desperate not to be.