how to select Empty column in pivot for display row

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

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

how to select Empty column in pivot for display row_no