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.