how to select Empty column in pivot for display row_no

Question

how to select Empty column in pivot

im using pivot in my sql server to display rows as columns in a report,i want to select empty column in my sql pivot 

 

empid	name	1	2	3
1	a	X	X	L
2	b	X	CL	X

it is possible to select like this

my expected answer is to select row no in sql pivot column

add a new column for s.no 

 

SET @query='SELECT Empid,EmployeeName,Department,'+@cols+' from

(select Empid,EmployeeName,department,day(Attdate)[dtDay],present from temp1 ) x

pivot

(

Max(present)

for dtDay in ('+@cols+'

)) p'

EXECUTE (@query);

i cant add a new column in my pivot table

 

s.no	empid	name	1	2	Totaldays
1	1	a	X	X	2
2	2	b	X	CL	1