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