Hello All

I want to Split multirow resultset to single row, multicolumn resultset
my table is
ProfileDetail(P rofileId bigint, PropertyId bigint PropertyValue nvarchar(400))

Table data :

ProfileId PropertyId PropertyValue
97 1 lokendra
97 2 bhatt
97 3 m
97 4 Oct 23 1987 12:00AM
97 5 2344
97 6 ...