modify sql query

See more:

SQL

DataTable

ATTID int
BID int
Bcode varchar
Name varchar
Date datetime
Ptype varchar


I want to display only Bcode Name Date & Ptype in foll query
plz help me

----------------------------------------------------------

DECLARE @columns VARCHAR(8000)

SELECT @columns = COALESCE(@columns + ',[' + cast(date as varchar(11)) + 

']',
'[' + cast(date as varchar(11))+ ']')
FROM tbl_K_Attendance
GROUP BY date


DECLARE @query VARCHAR(8000)

SET @query = '
select * from tbl_K_Attendance
PIVOT
(
MAX(Ptype)
FOR [date]
IN (' + @columns + ')
)
AS p'

EXECUTE(@query)

[Modified: added pre tags]