demo, Sql Server - rextester

Language: Layout:

declare @tmp table (id int, [Name]  varchar(100), Customer  varchar(100), dob datetime, orderno int)
	insert into @tmp select  1, 'name1','c1',getdate(),123
	insert into @tmp select  2,'name2',null,getdate(),123
    insert into @tmp select  3,'name3',null,null,null

SELECT t.*, 
       t1.notpopulated 
FROM   @tmp t 
       INNER JOIN (SELECT 4 - Count(*) AS NotPopulated, 
                          id 
                   FROM 
       (SELECT id, 
               u.x, 
               u.y 
        FROM   (SELECT id, 
                       Cast([name]AS VARCHAR(100))    [name], 
                       Cast(customer AS VARCHAR(100)) AS customer, 
                       Cast(dob AS VARCHAR(100))      AS dob1, 
                       Cast(orderno AS VARCHAR(100))  orderno 
                FROM   @tmp) AS s 
               UNPIVOT ( [y] 
                       FOR [x] IN ([name], 
                                   [Customer], 
                                   dob1, 
                                   [orderno]) ) u) t 
                   GROUP  BY id) t1 
               ON t1.id = t.id

View schema
Execution time: 0,01 sec, rows selected: 3, rows affected: 3, absolute service time: 0,2 sec, absolute service time: 0,2 sec